Calculated Percentages (filtered)

[bgarland]

Hi all. I'm trying to re-create a spreadsheet calculation (attached photo). It's pretty simple except for the fact that the percentage needs to only calculate where the dimension = "High". In the screenshot you can see that the cell formula specifically calls out that subtotal line for division by the grand total. I am familiar with the DAX expression to DIVIDE where CALCULATE is used with ALLSELECTED, but I don't know how to hard-code that dimension filter into the expression.

[v-yuta-msft · Accepted solution]

Hi bgarland ,

Try measure below and check if it can meet your requirement:

Resukt =
CALCULATE (
    aggregation,
    Table[dimension] = "high",
    ALLSELECTED ( Table[Column] )
)

Regards,

Jimmy Tao

[bgarland]

That should work. Thanks!