Forum Discussion

Shan_Drex12's avatar
Shan_Drex12
Helper I
5 years ago
Solved

Ranking question error

HI All,   I'm trying to do a ranking based on the highest accumulated days for detention.   I have the formula below, but the ranking seems to be out of order: Rank = RANKX(ALL(Sheet1[Material ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Shan_Drex12 , Make sure # of Days in Detention is  COUNT(Sheet1[# of Days in Detention]). it should NOT be un/not summarized

 

Formula seems correct

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

  • Shan_Drex12's avatar
    Shan_Drex12
    Helper I
    5 years ago

    Hi amitchandak, if I don't use the 'don't summarize' table it messes up with the number of detention days I have. Inside of the query editer I did the difference between two dates. Also, for some reason I keep getting an error every time I try to share sample data, sorry I couldn't upload!

    • Shan_Drex12's avatar
      Shan_Drex12
      Helper I
      5 years ago

      I used this formula:  inside of the power query to get the days detention by using this formula: Duration.Days(Duration.From([#"Today's Date"]-[Trailer Check In Time])) - 2