DIVISION OF VALUES IN THE SAME COLUMN OF A TABLE

[Anonymous]

Hello All,

We are not able to calculate the below requirement. Please guide us.

We want the requirement as :

a) 5 divided by 7 and the result should be 71%

b) 5 divivded by 20 and the result should be 25%

c) 16 divivded by 31 and the result should be 52%

d) 55 divided by 63 and the result should be 87%

Thanks in Advance.

Regards,

Vivek Chavan.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to use HASONEVALUE Function to create measures to get the percent as requested. For example:

Percent1 =
IF (
    HASONEVALUE ( total[Index] ),
    MAX ( total[a] ),
    DIVIDE (
        SUMX ( FILTER ( total, total[Index] = 1 ), total[a] ),
        SUMX ( FILTER ( total, total[Index] = 2 ), total[a] )
    )
)

Regards,

Cherie