topic Understand Nested Calculate dax Code in DAX Commands and Tips

Understand Nested Calculate dax Code

han_rj — Tue, 21 Jan 2025 09:48:22 GMT

Hi All,

I am exploring nested calculate dax, out of this dax I was expecting only Audio Sales to be displayed but the filter context on Product Category is retained in Measure Calculates measures. Please may I have help understand what I am missing.

DataModel:

Re: Understand Nested Calculate dax Code

bhanu_gautam — Tue, 21 Jan 2025 09:28:07 GMT

han_rj The issue with your DAX formula is that the nested CALCULATE function does not work as expected because the inner CALCULATE does not return a scalar value that can be used in the outer CALCULATE

Try this

Measures =
VAR calc = CALCULATE([Sales Amount], 'Product Category'[Category] = "Audio")
RETURN calc

Re: Understand Nested Calculate dax Code

sanalytics — Tue, 21 Jan 2025 10:45:31 GMT

han_rj
why you are using variable? variable scope is limited..
Just use CALCULATE([Sales Amount], 'Product Category'[Category] = "Audio")
Or
CALCULATE([Sales Amount],FILTER(ALL( 'Product Category'[Category] ),'Product Category'[Category] = "Audio") )
This is not the case of nested calculate.

Regards

sanalytics

Re: Understand Nested Calculate dax Code

johnt75 — Tue, 21 Jan 2025 10:54:29 GMT

Variables in DAX are not really variable, they are constants. They are only ever evaluated once, and then they do not change. So your calc variable is evaluated in the original filter context, and the subsequent CALCULATE has no effect on that.