Average of a measure by category

[CetinT]

Hi All,

I want to calculate average of Item Cost/NetPrice % column by Subcategory. This column is a measure. Could you help me about this? 

It has to be like (28,01%+41,43%+23,98%)/3(Carpaccio category has 3 Item)=31,14% after this I will compare Item Cost/NetPrice % with new average. This has to be for each subcategory.

[tamerj1 · Accepted solution]

Hi @CetinT 

please try

Subcategory Average =
AVERAGEX (
CALCULATETABLE ( VALUES ( 'Product'[Product] ), ALL ( 'Product'[Product] ) ),
[Item Cost/NetPrice %]
)

[CetinT]

Thanks a lot. This measure solved my problem. 👋

[andhiii079845]

Please show the underlaying data structure. Are there measures or other tables involved? 

[CetinT]

There is Product and Transaction tables. Max Net Price and Max Cost Price are measures and dividing Max Cost Price to Max Net Price to finding ItemCost/NetPrice % as a measure