Forum Discussion
Exclude specific value from a subtotal in a table
How can I exclude a specific value from a subtotal? Here is an example of what i'm looking to do. I want to display A,B,C but in the subtotal for the Categories i only want it to total B,C and then role that same logic up through the hierarchy so the TOTAL is the Category 1 & Category 2 Subtotals.
1 Reply
augiedog23 , Assume you already have measure m1, try a new measure like
if( Not(isinscope(Table[Category])), calculate([M1], Table[Category] in {"B", "C"}), [M1])
refer
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
