Help with the Dax to find the average.

[Anonymous]

Hello All,

I have a table similar to this:

I need to find the average of "ID" with the maximum "value" of each "num".

In this case - I need the average of A to be = (5+6+7)/(3) = 6.

Looking forward to your help!

[Anonymous · Accepted solution]

hi @Anonymous 

Create this measure

Measure = CALCULATE(AVERAGEX('Table',CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[ID],'Table'[Num]))),ALLEXCEPT('Table','Table'[ID]))

[Anonymous]

Thank for your quick response. But I just forgot to mention that "Value" is a calculated measure and it shows an error if I try to include it in Max.

What should I do now?