Exclude specific value from a subtotal in a table

[augiedog23]

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.

[amitchandak]

@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