Forum Discussion

Haidannx's avatar
Haidannx
Helper I
6 years ago
Solved

Ranking by category

Hello guys,   I`ve a data set like below:   Request id Price 456 $1568 456 $1569 456 $1570 456 $1571 456 $1572 456 $1573 456 $1574 456 $1575 456 $1576 4...
Need Help
Tips and Tricks
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Haidannx ,

     

    Create Measure like below:

    Measure  = RANKX(ALL('Table'), CALCULATE(sum('Table'[Price])))
     
    Attaching Screen shot for your reference:

    Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Haidannx

    Use the rankx function to create the column. 

     

     

    Rank Column = RANKX(FILTER('Table','Table'[Request id]=EARLIER('Table'[Request id])),'Table'[Price],,DESC,Dense)

     

     

     

    Paul Zheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Haidannx

Use the rankx function to create the column. 

 

 

Rank Column = RANKX(FILTER('Table','Table'[Request id]=EARLIER('Table'[Request id])),'Table'[Price],,DESC,Dense)

 

 

 

Paul Zheng

  • Haidannx's avatar
    Haidannx
    Helper I
    6 years ago

    Anonymous  

    It worked

    Many thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Haidannx 

      If my solution solved your problem, please don't forget mark my reply.😝

      Best,
      Paul