Page#157 - "Total Sales" Not Filtering Correctly

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.
Post Reply
kathung
Posts: 2
Joined: Sat May 25, 2019 6:43 am

Page#157 - "Total Sales" Not Filtering Correctly

Postby kathung » Sat May 25, 2019 6:57 am

Hi -
I am on page 157, and got the Total Sales as in the attached file Capture1. I checked the relationship (in attached file Capture2) but don't understand what I did wrong. Can you please help?

Thank you!

Katherine
Attachments
Capture2.PNG
Capture2.PNG (113.61 KiB) Viewed 1916 times
Capture1.PNG
Capture1.PNG (154.16 KiB) Viewed 1916 times
Top
kathung
Posts: 2
Joined: Sat May 25, 2019 6:43 am

Re: Page#157 - "Total Sales" Not Filtering Correctly

Postby kathung » Sun May 26, 2019 3:35 am

I figured out - I should have used Period from the 'BudgetPeriod' table, not the 'Budget' table.
Top
MattAllington
Posts: 1154
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Page#157 - "Total Sales" Not Filtering Correctly

Postby MattAllington » Wed May 29, 2019 8:08 pm

Glad you worked it out.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Top
Post Reply

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

Who is online

Users browsing this forum: No registered users and 1 guest