Using Filter Inside Calculate

A dedicated forum to help people when working through the book "Learn to Write DAX"
Posts: 2
Joined: Fri Apr 13, 2018 11:31 pm

Using Filter Inside Calculate

Postby Almond » Fri Apr 13, 2018 11:44 pm


I'm new to DAX and am working through the book. I have a question about the "Calculating Lifetime Customer Purchases" example (sorry, I can't see the page numbers on the Kindle version). What is the purpose of wrapping CALCULATE around the COUNTROWS/FILTER function? As far as I can tell, it works just fine without CALCULATE.

Thank you for your help!

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

Re: Using Filter Inside Calculate

Postby MattAllington » Mon Apr 16, 2018 7:26 am

What formula would you write to count the number of customers that have sales > 5000 over all time?
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
[URL=]Power BI Online Training[/URL]

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

Who is online

Users browsing this forum: No registered users and 1 guest