Practice Exercise 60

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.
elrcie
Posts: 3
Joined: Wed Oct 09, 2019 2:42 am

Practice Exercise 60

Postby elrcie » Wed Oct 09, 2019 2:48 am

Hi
=COUNTROWS(FILTER(Products,[Total Sales]>0 && [Total Sales]<10000))

Seems to work without Calculate. Is there any reason that this is also not an acceptable solution?

Thanks!

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

Re: Practice Exercise 60

Postby MattAllington » Thu Oct 10, 2019 9:21 pm

The above is perfectly fine. In this case it is the same, in other cases this won’t work. Eg what are the total sales of these products? In that case you need to keep the filter and use calculate.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

elrcie
Posts: 3
Joined: Wed Oct 09, 2019 2:42 am

Re: Practice Exercise 60

Postby elrcie » Mon Oct 14, 2019 5:37 am

Many thanks! Yes, I understand if the purpose was to total sales, calculate would be required. Again, thanks!


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

Who is online

Users browsing this forum: No registered users and 1 guest