Hi, i was searching yesterday within the community for a solution but did not find anything that matches my case. If this was already discussed i would be glad if somebody can piont out the post. I would like to calculate the average price for different categories. The difficulity is that i have rows with different quantities. Here an example lineProdcut TypeqtyTotal pricePlatform 1A15€ 61.51Production lineProduct nameqtytotal price (not price per piece) I don't know how i generate the correct calculation. I want to calculate the sum of total price and devide this by the sum of qty. Here is an excerpt of the table lineProdcut TypeqtyPricePrice per piecePlatform 1A15€ 61.51€ 4.10Platform 1B14€ 60.32€ 4.31Platform 1G21€ 60.32€ 2.87Platform 1G42€ 58.47€ 1.39Platform 1J33€ 58.47€ 1.77Platform 1W49€ 139.00€ 2.84Platform 2J15€ 281.88€ 18.79Platform 2Q27€ 143.39€ 5.31Platform 2R13€ 57.04€ 4.39Platform 2H8€ 57.04€ 7.13Platform 2F12€ 93.04€ 7.75Platform 2B20€ 206.89€ 10.34Platform 2B35€ 207.36€ 5.92Platform 2C25€ 126.34€ 5.05Platform 2R24€ 126.34€ 5.26Platform 3T39€ 131.94€ 3.38Platform 3O2€ 138.16€ 69.08Platform 3P47€ 56.24€ 1.20Platform 3Y44€ 64.48€ 1.47Platform 3W43€ 253.28€ 5.89Platform 3R20€ 282.25€ 14.11Platform 3D27€ 210.94€ 7.81 These are the average values that i would like to calculate: LineTotal QtyTotal PriceAveragePlatform 1174€ 438.09 € 2.52Platform 2179€ 1,299.32 € 7.26Platform 3222€ 1,137.29 € 5.12 I am sure that there is a pretty easy solution which i did not consider. Thanks for you help!

Which calculations you have used.In case you have used this, hope you created it is a measure, not Column divide(sum(price),sum(qty)) Please share the formula you created. It should be dynamic. Unless there is join missing. Or Interactions are off.

Calculate the average per category | Microsoft Fabric Community

Open Side Menu

Skip to content

Microsoft Fabric Community
Power BI forums
Desktop

Forum Discussion

Related content

Average of categories over vendor

Calculate Average per category

DAX calculation weighted average per category

AVERAGE BY CATEGORY

Calculate Average by Month and Category