Matrix Measures in rows and Percentage Of another measure

[dsi]

 

Hello,
I have a matrix visual with a switch over from columns to rows.

Now I would like to calculate the percentage for each row.
E.g

            -> Year/Month

Measure    |Value  |% from Masure C

Measure A | 10k    | 10%
Measure B | 90k    | 90%
Measure C | 100k  | 100%

Any ideas or hints?

Thank you in advanced

[v-cgao-msft · Accepted solution]

Hi @dsi ,

Some slight adjustments are needed.

1. Create table -> enter data -> Table2:

2. then please new measures like:

Measure = 
SWITCH(
    MAX('Table2'[Category]),
    "Sales GER",[Sales GER],
    "Sales USA",[Sales USA],
    "Sales other",[Sales other],
    "Sales Total",[Sales Total]
)

Measure 2 = 
SWITCH(
    MAX('Table2'[Category]),
    "Sales GER",DIVIDE([Sales GER],[Sales Total]),
    "Sales USA",DIVIDE([Sales USA],[Sales Total]),
    "Sales other",DIVIDE([Sales other],[Sales Total]),
    "Sales Total",DIVIDE([Sales Total],[Sales Total])
)

3. result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[dsi]

Thanks for Help. 

I‘m also found a similar solution.
It works fine.

Have a nice day