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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

There could be a visualisation that helps but can you please provide more detail on your example.

 

Such as what your expected output might look like in data form?

keknight's avatar
keknight
Frequent Visitor
8 years ago

Sure! I'm able to do exactly what I want using Pandas (Python). See above example, where some datapoints have both scores plotted, and some only have one.