Forum Discussion

keknight's avatar
keknight
Frequent Visitor
8 years ago
Solved

Yet another ranking question

I have a large table of data, separated by subject areas (100 rows per subject). The data has been scored by subject according to two scoring methods.  Here's a very abbreviated sample:   Subjec...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi keknight,

     

    Please create below measures:

    Sum1 = SUM(Institution[Score 1])
Sum2 = SUM(Institution[Score 2])

Ranking1 = RANKX(ALL(Institution),[Sum1],,DESC,Dense)
Ranking2 = RANKX(ALL(Institution),[Sum2],,DESC,Dense)

Top2 = IF([Ranking1] <=2 || [Ranking2] <=2,1,0)

    Add measure [Top2] into visual level filter, set its value to 1.

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi keknight,

 

Please create below measures:

Sum1 = SUM(Institution[Score 1])
Sum2 = SUM(Institution[Score 2])

Ranking1 = RANKX(ALL(Institution),[Sum1],,DESC,Dense)
Ranking2 = RANKX(ALL(Institution),[Sum2],,DESC,Dense)

Top2 = IF([Ranking1] <=2 || [Ranking2] <=2,1,0)

Add measure [Top2] into visual level filter, set its value to 1.

Best regards,

Yuliana Gu