Forum Discussion

abehrmann's avatar
abehrmann
Icon for Helper II rankHelper II
8 years ago

Need help Ranking

I am attempting to rank some of our employees based on a few sets of metrics. 

 

Below is a matrix of the aggregated data that i would like to rank them by and a sample of the raw data. 

 

I cannot seem to rank them based on the aggregated data.. any help would be appreciated !! 

 

 

 

Need Help

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi abehrmann,

     

    Which aggregated data should be based on to calculate rank? Is it a measure? If so, you could try this similar formula:

    Rank =
    RANKX ( ALL ( Table ), [Measure],, ASC, DENSE )

     

    Regards,

    Yuliana Gu

    • abehrmann's avatar
      abehrmann
      Icon for Helper II rankHelper II
      8 years ago

      I attepted to use that suggestion but the ranking is showing up very odd 

       

       

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi abehrmann,

         

        What is the formula of [Customer Total total for Assigned to]? Would you please share a sample .pbix file? Do not send me the file with full dataset and senssitive data, just show me the dummy data.

         

        Regards,

        Yuliana Gu