Forum Discussion
URGENT!! Ranking measure not working.
Anonymous
I was wondering why cannot you use this patternRANKX( 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
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.
Super UserAnonymous
Okay, not sure why you are using two rank functions. Will it be possible for you to share the pbix file with sample data? and expected result.
yeah sure, Here is the link to the sample dashboard: https://drive.google.com/file/d/1_-nOngtU4ZKV_Ju-_km_pm4V-FELqRN6/view?usp=sharing
and here is the expected result:- tharunkumarRTK
Anonymous
I was wondering why cannot you use this patternRANKX( 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
Thanks a lot tharunkumarRTK @ for the help!
- Ashish_Mathur
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.
Thanks a lot Ashish_Mathur for the help!