Forum Discussion
Solved
Cost Distribution %Row Total
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...
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.
always happy to help