How to enable total at below row (percentage)

[Anonymous]

Hi all,

Any suggestion to enable percentage for total of start, joint and end at below row? Please refer current and what i expected.

Current

Expected

Regards,

Nuha

[Dhairya]

Hey @Anonymous 
Can you please explain how you have calculated the percentage that you have shown in the expected output?

[Anonymous]

Hi @Dhairya ,

We take Start as example.

start (%) = sum of start (unit) / sum of usage (unit) 

Regards,

Nuha

[Dhairya]

Please trying this by creating following measures

total usage units = SUM(YourTableName[Usage units])

sum of usage = SUMX(ALLSELECTED('YourTableName'[Machine]),[total usage units])

total start units = SUM(YourTableName[start units])

sum of start (unit) = SUMX(ALLSELECTED('YourTableName'[Machine]),[total start units])
 
start (%) = IF(
ISINSCOPE([Machine]),
[total start units],
DIVIDE(sum of start (unit),
[sum of usage],
0
)
)

create similar measures for end and joint percentage

if still you are facing any issues please share dataset which I can copy and try on my system.