Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / #10 When should I use FILTER() with CALCULATE?
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

#10 When should I use FILTER() with CALCULATE?

Posted
Updated
ByRuth Pozuelo Martinez

When should you use the filter function with CALCULATE?
As you probably have noticed, sometimes people use a column in the filter part of CALCULATE and sometimes they use the FILTER function.


The question is, when should you use what? In this video I will try to clarify that question.

Watch the tutorial:

DAX Fridays! #78: When should I use FILTER() with CALCULATE?
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents