Forum Discussion
Average everything else
- 4 years ago
Hi stjimi
From your example, it looks like a measure such as this would give the result you want:
Average of others = CALCULATE ( [Average], EXCEPT ( ALLSELECTED ( YourTable[Jurisdiction] ), VALUES ( YourTable[Jurisdiction] ) ) )This assumes a measure [Average] is already defined.
The EXCEPT ( ... ) expression creates a modified filter on Jurisdiction, by taking the filter on Jurisdiction applying to the overall visual, and removing the value(s) of Jurisdiction visible in the current filter context, i.e. removes the single value from the current row of your table in your example.
Regards,
Owen
Thanks so much, Owen. This makes sense. How would I go about defining a measure for the Average? Would I do this with a 'new measure'. Sorry about the simple question.
It would just be AVERAGE ( Table1[Column1] ) where you substitute whatever column you're wanting to average instead of my placeholder.