Page89 46.Modifying Practice Exercise 44

A dedicated forum to help people when working through the book "Learn to Write DAX"
yatou_127
Posts: 5
Joined: Thu Mar 05, 2020 12:41 am

Page89 46.Modifying Practice Exercise 44

Postby yatou_127 » Mon Mar 23, 2020 6:24 pm

Hi, when processing exercise 44, adding a slicer of color to enable values in pivot table, an error message pop up as attached after selecting "color " from products table.

IF HASONEVALUE returns a table of multiple value, which is expected. any work around to enable slicer as the book does? I am using Office 365. Thanks!!
Attachments
Capture.PNG
Capture.PNG (32.37 KiB) Viewed 1161 times

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

Re: Page89 46.Modifying Practice Exercise 44

Postby MattAllington » Mon Apr 06, 2020 7:15 am

My guess is your formula is not written correctly. Can you post it?
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 4 guests

cron