Forum Discussion
Ranjith_96
Helper I
Helper ICALCULATE function behaviour
Hi Power BI Community, This is my DAX ChairsSales = CALCULATE(SUM(Orders[Sales]),Orders[Sub-Category]="Chairs") Please refer the below image, I have written the Sub Category = Chairs in the CALU...
Ranjith_96 if you understood it correctly, tell me what is the expected output of the following measure if you put it in the matrix visual. Try to answer it without actually testing it in your visual, If you are able to answer, it means you understood the concept.
ChairsSales = CALCULATE(SUM(Orders[Sales]),Orders[Category]="Furniture")
parry2k
Super User
Super UserRanjith_96 you need to understand how row context played role in the measures.