Forum Discussion

Wael03's avatar
Wael03
Helper I
3 years ago
Solved

Percentage in a matrix

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 !!

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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