Forum Discussion
Ranking Subjects.
Hello janisCNH
I think the solution explain by asocorro is good, but you may need something more.
If your ranking is used for selected objects (just like slicer for example) you have to replace the ALL keywork by the ALLSELECTED.
It should recalculate the ranking based only on the selected members.
Sebastien
Create a measure [Subject Count] and then rank based on it, with a measure [Subject Rank] = RANKX(ALL(TableName[Subject]), [Subject Count]). Create a table with the columns Subject and [Subject Rank].
As to displaying the top 5, one way is to filter the visual with [Subject Rank] <= 5.
Hello janisCNH
I think the solution explain by asocorro is good, but you may need something more.
If your ranking is used for selected objects (just like slicer for example) you have to replace the ALL keywork by the ALLSELECTED.
It should recalculate the ranking based only on the selected members.
Sebastien