Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
hi @Anonymous
Create this measure
Measure = CALCULATE(AVERAGEX('Table',CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[ID],'Table'[Num]))),ALLEXCEPT('Table','Table'[ID]))
hi @Anonymous
Create this measure
Measure = CALCULATE(AVERAGEX('Table',CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[ID],'Table'[Num]))),ALLEXCEPT('Table','Table'[ID]))
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?
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |