Power Bi formula for % Average

[amk0592]

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% which is not right as its taking average of % values. I want to take sum of zero based consumption and sum of zb wastage absolute and then divide and take % which will give me correct % wastage value. How to do it? so that i just select any month and it gives me % wastage value for all materials in that month

Month	Material	Zero based consumption	ZB wastage absolute	% Wastage
Jan	Material A	1,680,439	347,006	21%
Jan	Material B	3,124,885	542,495	17%
Jan	Material C	284,719	(13,224)	-5%
Feb	Material A	404,114	159,347	39%
Feb	Material B	305,169	67,219	22%
Feb	Material C	716,636	440,629	61%
	Sum	6,515,963	1,543,472
		Total Wastage (%)	24% (correct value)	26.1%

[ibarrau · Accepted solution]

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, 

[amk0592]

dear i have updated my question for details, please review again

[ibarrau]

Have you tried the DAX formula for a new measure? I have updated to match the column names.