find percentage with specific number

[slam]

Please help me I want to calcute percentage with z (90)( e.g 90/12 a row) in power bi, how to write dax

item	valua	%
a	12	13.3
b	14	15.6
c	15	16.7
d	16	17.8
e	26	28.9
z	90

best regards

[amitchandak · Accepted solution]

@slam ,

new column = divide([valua], sumx(filter(Table, Table[item] ="z"),[valua]) )

or a measure

new column = divide(sum(Table[valua]), sumx(filter(allselected(Table), Table[item] ="z"),[valua]) )

[slam · Accepted solution]

Thank you so much!

[amitchandak · Accepted solution]

@slam ,

new column = divide([valua], sumx(filter(Table, Table[item] ="z"),[valua]) )

or a measure

new column = divide(sum(Table[valua]), sumx(filter(allselected(Table), Table[item] ="z"),[valua]) )