Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago
Solved

Silly ranking question

Hi,   I basically i have two columns:   Linkedin 500 Facebook 400  Twitter 350 Others 370   I want these values to be ranked so that anything that is not "Others" is ranked and presented in ...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    CarlsBerg999,

     

    Please confirm that you created measures, not calculated columns.

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago

I'm getting the same Rank (1) for all of these. I think the formula is making SUM for entire "Amount" column which is the same for all values. Am i doing something wrong? In the example, the Total Amount = SUM(RankTest[Amount])=1620 for all values. Therefore the rank is the same for all. 

DataInsights's avatar
DataInsights
Super User
5 years ago

CarlsBerg999,

 

Please confirm that you created measures, not calculated columns.