Calculate average within category

[Marit]

Hi!

Earlier I asked about how I could calculate an average above several categories in a line plot. I used the DAX syntax:

New measure=CALCULATE(AVERAGE('Table'[Value]), ALL('Table'[Category1]),

ALL('Table'[Category2]), ALL('Table'[Category3]))

This worked really fine. However, now I want to calculate an average within category1 and above all other categories. Thus, I want an average for each level in category1. Is this possible?

Regards Marit

[amitchandak]

@Marit , check if these two can help

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

[MFelix · Accepted solution]

Hi @Marit ,

You just need to calculate the average for each category:

AVERAGE 1= CALCULATE(AVERAGE('Table'[Value]); ALLSELECTED(Table[Category1])

Just repeat this for each of the category.