Forum Discussion
Total comes out as zero (while using Switch statement)
JustinDoh1 , when you use rows context example min/max (min(A) = "A") in a measure. the calculations are done at row level. And unless we use allselected and all, we are still on the same visual row.
In such a case, the grand total is recalculated. It misses the context as it does not have a name. That we why we take the help of summarize or values to group data from rows level to grand total level
As, summarize do not work same as the visual table always, we need to work on our formula
is this different from
Thank you for your feedback.
I was using SWITCH, but my output is still very unstable. How do I go about wrapping up my calculate to be obvious and stable?
How do I go about "summarize or values to group data from rows level to grand total level"?
Do I go that in the Calculate function at VAR section or inside Switch area?
Thanks.
I have updated file here.