Forum Discussion
Solved
Measure behaviour in a table
Hi, I would like to create a measure that calculates an average Rank. This rank is measured across all my records and repeated against a category. I want to calculate the average of this rank agains...
Assuming your fact table is called 'fTable', try:
Average by Cat 2 = CALCULATE ( AVERAGE ( fTable[Rank] ), ALLEXCEPT ( fTable, fTable[Cat 2] ) )
Why is Three 12 and 15?
Because it has different Cat1
That is what the measure I posted delivers