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] ) )
Assuming your fact table is called 'fTable', try:
Average by Cat 2 =
CALCULATE ( AVERAGE ( fTable[Rank] ), ALLEXCEPT ( fTable, fTable[Cat 2] ) )
Your formula works fine for the first scenario, it's just that it doesn't change and will always be the same in my case.