Forum Discussion
Solved
Exclude values in Average calculation
Hi there I have a matrix showing product sales and I would like to see the average unit cost for each product. The problem is that the average is incorrect since it includes lines where QTY = bla...
Hi mnb_dk ,
Thanks for the reply from HotChilli , please allow me to provide another insight:
Here are the steps you can follow：
1. Create measure.
Measure = AVERAGEX( FILTER(ALL('Table'), 'Table'[Color]=MAX('Table'[Color])&&[QTY]<>BLANK()),[Unit costs])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
