get the percentage of a value out of the column

[Anonymous]

hello, 

i have a matrix with several groups, and i have a measure that calculates for each row the average of the last 6 months.

now i am looking for a way to get for each row the percentage of it out of its group.

for example the first row's percentage should be 23.9% >> 151049/SUM(all other values)

thank you very much for your help.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
ISINSCOPE('Table'[Group]) && NOT(ISINSCOPE('Table'[Group1])),
DIVIDE(
    [NNS Avg 6 Months],
     SUMX(
     FILTER(ALLSELECTED('Table'),
     'Table'[Sub-Category]=MAX('Table'[Sub-Category])),[Amount]))
,[NNS Avg 6 Months])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[johnt75]

You can use

sub cat % =
VAR currentValue = [NNS Avg 6 Months]
VAR totalValue =
    CALCULATE ( [NNS Avg 6 Months], ALLSELECTED ( 'Table'[Sub-category] ) )
RETURN
    DIVIDE ( currentValue, totalValue )