Forum Discussion
Solved
percentage calculation
Hi, please for help. I have table like this, and I need calculate values in column "per of X", it is calculated by formula "per of X = value / X" where X is sum of all values which has in name "x". ...
Hi petrk ,
I've made a test for your reference:
1\ I assuem there is a table(Table)
2\Add a measure
Per of X = Var CurrentItemValue =Max('Table'[value]) Var CurrentItemName= LEFT(SELECTEDVALUE('Table'[name]),1) Var SUMValue=CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),LEFT('Table'[name],1)=CurrentItemName)) RETURN CurrentItemValue/SUMValue3\Result
Best Regards,
Bof
Updated Measure:
Per_of_X =
DIVIDE (
SelectedValue(Table[value]),
[Total_X],
0 // To handle division by zero
)
