Solved: Percentage in a matrix

Wael03 · ‎06-28-2023

Hello,

I have this matrix :

As you can see, I have the total and also the percentage of the total as "show as percentage of grand total". But the thing is I would like to have the percentages depending on each level, let me explain.

I want the same percentage for the first level but then I would like the share of challenge and frictionless as subtotal so for example for the 2 first one instead of 4.05% and 1.69%, I would like to have 75% and 25%.

How can I do that ?

Thank you !!

Anonymous · ‎06-29-2023

HI @Wael03,

I'd like to suggest you take a look at the following link to know how to find the detail hierarchy levels of row context. You can use if statement to check the current row context and replace the specific level result with new Dax expressions.

Clever Hierarchy Handling in DAX - SQLBI
Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎06-29-2023

HI @Wael03,

I'd like to suggest you take a look at the following link to know how to find the detail hierarchy levels of row context. You can use if statement to check the current row context and replace the specific level result with new Dax expressions.

Clever Hierarchy Handling in DAX - SQLBI
Regards,

Xiaoxin Sheng