Forum Discussion
Solved
Power Bi formula for % Average
Need Help, As seen in below table, i want to have a graph with % wastage value month vise of different materials. Power bi takes average of % wastage and then gives me total wastage value of 26.1...
Hi, this sounds like a DAX problem and not a power query. I'm not quite sure about the formula because it was confusing.
However you can try this for a New Measure in DAX:
% value = DIVIDE ( SUM(Table[ZB wastage absolute]), SUM(Table[Zero based consumption]), 0 )Hope this helps,
Hi, this sounds like a DAX problem and not a power query. I'm not quite sure about the formula because it was confusing.
However you can try this for a New Measure in DAX:
% value =
DIVIDE (
SUM(Table[ZB wastage absolute]),
SUM(Table[Zero based consumption]),
0
)
Hope this helps,
