#51 & #52 p99

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
mfl
Posts: 2
Joined: Tue Jan 09, 2018 9:46 pm

#51 & #52 p99

Postby mfl » Tue Jan 09, 2018 10:30 pm

Is this the correct matrix?
scpbi 51-52.jpg
scpbi 51-52.jpg (45.63 KiB) Viewed 1523 times

The measure for mSelectedDate% is similar to the answer on p181 but not showing the relative %?
While mTotalSelectedDate% is working fine.

thanks

P3Tom
Posts: 6
Joined: Tue Jan 09, 2018 4:20 pm

Re: #51 & #52 p99

Postby P3Tom » Wed Jan 10, 2018 8:40 am

mfl,

An excellent observation! I have thought about this one for a while:

You have the correct matrix, but perhaps not the correct slicer.

The example on page 99 of Supercharge Power BI uses a slicer with a column from the same table (Customers[Occupation]) as the column used on the rows of the pivot (Customers[NumberCarsOwned]). However, in your example, the date slicer belongs to a calendar table that has no presence inside of the pivot.

This may sound like splitting hairs, but I think the point is valid. Other places I have seen ALLSELECTED used would include parent tables of the column that was used on pivot/matrix rows, but Calendar is on the other side of a many-to-many relationship with Customers.

Marco Russo and Alberto Ferrari, authors of the Definitive Guide to DAX, have said that ALLSELECTED is a dangerous function that is only valid in specific instances, as the current example may show.

Tom

mfl
Posts: 2
Joined: Tue Jan 09, 2018 9:46 pm

Re: #51 & #52 p99

Postby mfl » Thu Jan 11, 2018 10:55 am

P3Tom,

Thanks for the insight

I can confirm #49 & #50 p99 works fine - used "Manual" in the slicer below

scpbi 49-50.jpg
scpbi 49-50.jpg (31.81 KiB) Viewed 1504 times


Just need to work out how to fix #51 & #52 now


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 1 guest