Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I really need your help, I would like to calculate percentage from 2 calculated measure. however the percentage measure is not summing each row percentage instead applying the formula on the subtotal here is the document:
The percentage is showing 10% because the formula applied there , instead i just want to calculate 6%+3%+6$%+4%+8%+5%+4%+4%+5%+7%+4%+4%+3%=63%
here is the formula for percentage:
Solved! Go to Solution.
@bryanrendra , Try this out
DIVIDE(abs(([LatestPrice Excise]-[PreviousPrice Excise])),[PreviousPrice Excise],0)
Or Sumx(Values(Table[Group]),[Percentage])
Here group is your rows/axis/group by you used
@bryanrendra , Try this out
DIVIDE(abs(([LatestPrice Excise]-[PreviousPrice Excise])),[PreviousPrice Excise],0)
Or Sumx(Values(Table[Group]),[Percentage])
Here group is your rows/axis/group by you used
Hi your solution is fully work, thank you so much Mr. Amitchandak
thank you for your answer, but it gave me 0 % to the all of the rows
Maybe you could try this:
Percentage =
SUMX (
VALUES ( Table[ColumnInYourVisual] ),
IF (
[LatestPrice Excise] = 0,
0,
DIVIDE (
ABS ( [LatestPrice Excise] - [PreviousPrice Excise] ),
[PreviousPrice Excise],
0
)
)
)
Read up on the concepts of SUMX and HASONEVALUE.
I am really new to power bi, could you help me please?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |