Calculate average of averages for each case ID

[tomekm]

Hello,

a) I'm trying to create a calculated column that will calculate the average of already computed averages, for each case ID. Below is my data. The last column is what im trying to get, and it should be responsive to any filters I apply later on.

b) In addition I also want to create an overall average calculation for all Cases looked at together, like this: calculation: Overall average for all cases: 20.65 (29.8+11.5/2)

Case	AVERAGE for each Case	Overall Average for Case
1a	27.68	29.8
1b	27.68	29.8
1c	27.68	29.8
1d	31.92	29.8
1e	31.92	29.8
1f	31.92	29.8
2a	10.5	11.5
2b	11.3	11.5
2c	12.7	11.5

Thank you.

[Cookistador · Accepted solution]

Hello,

The following measure should return the average for Case

Overall Average for Case =
CALCULATE(
AVERAGE( YourTable[CaseAVERAGE] ),
ALLEXCEPT( YourTable, YourTable[Case] )
)

This measure should return the overall average

Overall Average of Case Averages =
AVERAGEX(
VALUES( YourTable[Case] ),
CALCULATE( AVERAGE( YourTable[CaseAVERAGE] ) )
)

Let me know if you need more help 🙂

[tomekm]

Great! Thank you..