Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

URGENT!! Ranking measure not working.

Hello Power BI community!Preview   Can you help me with the below ranking code? This code is giving me the same ranking for different % of search order columns:    SortingOrderSearchOrder_Single...
"RANKX"
DAX
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Anonymous 

    I was wondering why cannot you use this pattern 

    RANKX( ALLSELECTED('df_Search Order (First)'[Search Order (First)])  , [Category_Occasion_SingleSelect%])

      


    If the post helps please give a thumbs up


    If it solves your issue, please accept it as the solution to help the other members find it more quickly.


    Tharun

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    I revised your measure to:

    Ranking SingleSelect = 
RANKX(ALLSELECTED('df_Search Order (First)'[Search Order (First)]), [Category_Occasion_SingleSelect%], , DESC, Dense)

    This also works

    Ranking SingleSelect 1 = 
RANK(DENSE,SUMMARIZE(ALLSELECTED('df_Search Order (First)'),'df_Search Order (First)'[Search Order (First)],"A",[Category_Occasion_SingleSelect%]),orderby([A],DESC))

    Hope this helps.

     

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

Anonymous 

Have you used any other column to sort this column ? if yes then you need to include the sorting column into ALL() incase if you want to remove filters on that column.

'df_Search Order (First)'[Search Order (First)

 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello tharunkumarRTK !

     

    I'm not sroting 'df_Search Order (First)'[Search Order (First)] column with any other column. I'm not sure why this is happening