cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oldhasbeen Regular Visitor
Regular Visitor

What is purpose of FILTER command, esp. within CALCULATE?

Hi 

 

I'm following a training video explaining Table functions. I've created a Mesaure using a FILTER within a CALCULATE to calculate the amount of Sales per Category that come frorm orders of over 100:

 

DAX FILTER 1.PNG

To me, however, it seems easier to not use the FILTER command as CALCULATE alreay has a parameter which acts as a filter:

 

DAX F2.PNG

 

So - is there a good reason to use a FILTER command within a CALCULATE?

And if not, where else might FILTER be useful?

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: What is purpose of FILTER command, esp. within CALCULATE?

@oldhasbeen hope this post help





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




2 REPLIES 2
Highlighted
Super User
Super User

Re: What is purpose of FILTER command, esp. within CALCULATE?

@oldhasbeen hope this post help





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




oldhasbeen Regular Visitor
Regular Visitor

Re: What is purpose of FILTER command, esp. within CALCULATE?

Thanks Parry - very useful article