Matrix in Page 42

A dedicated forum to help people when working through the book "Learn to Write DAX"
carlos barberis
Posts: 6
Joined: Tue Oct 23, 2018 10:20 am

Matrix in Page 42

Postby carlos barberis » Tue Oct 29, 2019 11:44 am

Hi, Im triying to get the matrix shown in page 42, related to DistinctCount() customers by categories, but some thing I'm doing bad because when I put CalendarYears in columns, my figures in four years (2001 to 2004), are the same that Totals (18484), In other words, the four columns are equals than total column.
What I'm doing bad? I would appreciate your help
Carlos Barberis

MattAllington
Posts: 1067
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Matrix in Page 42

Postby MattAllington » Fri Nov 01, 2019 4:27 pm

It sounds to me like an issue with your relationship between the calendar table and the sales table. Go and check and make sure that it is correctly joined between the date columns in both tables
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 0 guests