Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
May i know is it possible to disable the auto summarized total in a matrix visual ?
I know that when the rows are collapsed, matrix will automatically apply function Sum to the figures. However, in my report layout, the total up values are meaningless.
So, is it possible to delete the total when rows are collapse ? (delete as in to show nothing in the figure column)
To change from:
change to:
Thanks
Regards,
Solved! Go to Solution.
@teng1 , You can disable subtotal and you use the per row option to disable particular subtotal
You can also control it using, isinscope
Switch(True(),
isinscope(Table[Lowset level]), [Meausre],
isinscope(Table[level 1]), [Measure 2],
isinscope(Table[level 2]), blank())
@teng1 , You can disable subtotal and you use the per row option to disable particular subtotal
You can also control it using, isinscope
Switch(True(),
isinscope(Table[Lowset level]), [Meausre],
isinscope(Table[level 1]), [Measure 2],
isinscope(Table[level 2]), blank())
Hi amitchandak,
Thanks for showing the direction.
Here is what works for me.
Previously i made a mistake on the lowest level measure.
Regards.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |