How really works Calculate inside Calculate?

DAX
1

Hi,

I would like to know why the total is the same in all columns even all the formulas are different.

The table is built inside the “Variables” page.

I attach the pbix file.

08 - Mastering DAX Calculations.pbix (396.2 KB)

Thank you

2

Hi @danieldecaboriveiro - This is how Power BI works. In Individual rows there is a Filter context coming from Customer and getting applied on the calculation.

However in the Total there is no filter context, so in below it is considering all the Products as they have Sales above the threshold value and giving same total.

VAR __TopProducts = FILTER(Products,[Total Sales]>__ProfitThreshold)

Thanks
Ankit J

1 Like
3

Thanks @ankit . I was forgetting that point when I was practicing this measures.