topic Re: Average of a measure by category in DAX Commands and Tips

Average of a measure by category

CetinT — Wed, 08 Mar 2023 19:33:39 GMT

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.

Re: Average of a measure by category

andhiii079845 — Wed, 08 Mar 2023 20:05:11 GMT

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

Re: Average of a measure by category

CetinT — Fri, 10 Mar 2023 18:07:04 GMT

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

Re: Average of a measure by category

tamerj1 — Sat, 11 Mar 2023 17:31:58 GMT

Hi CetinT

please try

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

Re: Average of a measure by category

CetinT — Sat, 11 Mar 2023 18:42:52 GMT

Thanks a lot. This measure solved my problem. 👋