Forum Discussion
Helper ICALCULATE function behaviour
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")
Super UserRanjith_96 use KEEPFILTERS and check video on my YT channel on how it works: (1) Let's have a closer look at VALUES, DISTINCT and KEEPFILTERS DAX functions - Power BI - YouTube
ChairsSales = CALCULATE(SUM(Orders[Sales]),KEEPFILTERS(Orders[Sub-Category]="Chairs"))
Ranjith_96Hi parry2k ..Thanks much for your response,
However my concern is I wanted to know how the DAX function is operating in my case to give the values of chairs for all the categories which is = Furniture.
I knew, Using keepfilters, we can overcome with this,
My concern is how I am getting values of chairs for all the categories which is = Furniture. I wanted to understand how DAXs operating here to give that output. Could you pleas explain me on this. I watched the video, but couldnt help my case to understand how it executes.