How to calculate percent of subtotal in Matrix

[dkdirenzo]

Hi, I'm trying to create a DAX Measure or column to calculate a percent of subtotal by category on the left. For example, the total percent should be 100% for each category, and the % by asset class should be a percent of the subtotal, not the grand total. I've tried sumx, allselected, etc. but having trouble getting to what i need.

[Shahid12523 · Accepted solution]

[% of Category Subtotal] =
DIVIDE(
[Total Holdings],
CALCULATE(
[Total Holdings],
REMOVEFILTERS('YourTable'[Asset Class])
)
)

This gives you percent of subtotal by category—each category totals to 100%, not the grand total. Clean and dynamic.