Cost Distribution %Row Total

[Arvind_123]

Hi Team,

I have Device in row where month and types are in column.

the result I am getting in power bi is :

 but I need Month wise % row distribution in types that means I need addition of 2 click and 3 click would be 100%

for example find the ouput that I need which is easily available in excel

Thanks,

Arvind

[Arvind_123]

Hi @Daniel29195 ,

Thank you so much 🙂

It works perfrctly.

Regards,

Arvind

[Daniel29195]

always happy to help 

[Arvind_123]

Hi Team,

Anyone can Please help me out to reach above desire output in power bi.

Thanks,

Arvind

[Daniel29195 · Accepted solution]

hello @Arvind_123 

assuming that the second level pn the columns is a column from a table with values :  2 click , 3 click.

Can you please try this measure : 

measure =
var num = sum(table[col])
var denom =
calculate (
sum( table[col]) ,
allselected(table[click_col])

return
divide
( num,
denom,
0
)

let me know if it works .

best regards.