nesting calculate(count

[Anonymous]

What does nesting the CALCULATE(COUNT functions do? I guess to break it down and make it easier, what does the CALCULATE( do?

And COUNT(...)? So far have not found existing explanations sufficient to my understanding. Thanks

[v-jingzhang]

Hi @Anonymous 

CALCULATE is a very import and commonly used function in DAX. It can change the filter context of the expression it evaluates. In your example, COUNT('Table'[Column]) is the expression to be evaluated, after it there are usually some filters following. 

It's not easy to explain how it works in short sentences. Using some examples will help you understand it better. I found some articles and blogs that introduce how to understand CALCULATE function. Hope they would be helpful! 

CALCULATE function (DAX) - DAX | Microsoft Learn

CALCULATE – DAX Guide

Introducing CALCULATE in DAX - SQLBI

The CALCULATE Function In Power BI - DAX Tutorial - Microsoft Power BI Community

The DAX Calculate Function - Master It In 5 Minutes (acuitytraining.co.uk)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Hi Jing,

Thanks, this is very helpful.

Best,

Kendall