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] ) )
sorry, made a mistake to the table:
cat1 cat2 rank
A one 10
A two 10
B one 12
B three 12
C three 15
so the rank will always be the same across cat1 but it will be different for each cat2. But if you want to display each of the cat2 and their average rank by cat1 so:
one avg(10 and 11)
two avg(10)
three avg(12 and 15)
Why is Three 12 and 15?
Because it has different Cat1
That is what the measure I posted delivers