topic Re: URGENT!! Ranking measure not working. in DAX Commands and Tips

URGENT!! Ranking measure not working.

Anonymous — Thu, 07 Mar 2024 13:43:42 GMT

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_SingleSelect = VAR SelectedProducts = {"Search Order (First)", "Brand First", "Category First", "Flavour Variant First", "Format First", "Not Answered", "Nutritional Content First", "Others First", "Pack Size First", "Pack Type First", "Packaging Design First", "Price First", "Product Origin First", "Promotion First", "Returnable Packaging First", "Temperature First", "Try New First", "Unit Type First" } RETURN IF( max('df_Search Order (First)'[Search Order (First)]) IN SelectedProducts, RANKX( FILTER( ALL('df_Search Order (First)'[Search Order (First)]), 'df_Search Order (First)'[Search Order (First)] IN SelectedProducts ), [Ranking SingleSelect], , ASC ), 0 )

below is a screenshot of the measure -

Following are the reference measures used:

Category_Occasion_SingleSelect% = [DistinctCount_Category_Occasions_SingleSelect]/ [TotalSum_Category_Occasion_SingleSelect]

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

MFelix , amitchandak , Ashish_Mathur

Re: URGENT!! Ranking measure not working.

tharunkumarRTK — Thu, 07 Mar 2024 13:59:15 GMT

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

Re: URGENT!! Ranking measure not working.

Anonymous — Thu, 07 Mar 2024 14:16:55 GMT

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

Re: URGENT!! Ranking measure not working.

tharunkumarRTK — Thu, 07 Mar 2024 14:21:18 GMT

Anonymous

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.

Re: URGENT!! Ranking measure not working.

Anonymous — Thu, 07 Mar 2024 15:27:25 GMT

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:

Re: URGENT!! Ranking measure not working.

tharunkumarRTK — Thu, 07 Mar 2024 16:18:26 GMT

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

Re: URGENT!! Ranking measure not working.

Ashish_Mathur — Fri, 08 Mar 2024 00:20:08 GMT

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.

Re: URGENT!! Ranking measure not working.

Anonymous — Fri, 08 Mar 2024 09:27:44 GMT

Thanks a lot Ashish_Mathur for the help!

Re: URGENT!! Ranking measure not working.

Anonymous — Fri, 08 Mar 2024 09:28:27 GMT

Thanks a lot tharunkumarRTK @ for the help!