RANKX returns 1 for all ISO Codes

minnie_1 — Fri, 10 Nov 2023 15:24:17 GMT

Test Ranking2 = var test = Table[Slicer] var NumericValue =IF( CONTAINSSTRING(test, "%"), VALUE(SUBSTITUTE(test, "%", "")), IF (CONTAINSSTRING(test, "$"), VALUE(SUBSTITUTE(test, "$", "")), BLANK() )) return RANKX(FILTER(ALL(Table[IsoCode]), NumericValue), NumericValue,,ASC)

I want to rank ISO Code column based on value in Slicer. Slicer has both % and $ values based on selected column, so I created NumericValue variable to convert all values to type number and remove % or $ for calculation. My $ values are based on Sum of column grouped by ISO Code and % are based on Average of column grouped by ISO Code.

I tried different forms in expression field like :
1. returns 1 for all ISO Codes

MAXX(WinLossDataWithCountry,NumericValue)

2. returns different numbers with duplicate ranking but giving value 10000 and 400 same rank. So its wrong

SUMX(WinLossDataWithCountry,NumericValue)

Re: RANKX returns 1 for all ISO Codes

Jihwan_Kim — Sat, 11 Nov 2023 05:40:05 GMT

Hi,

I am not sure how your datamodel looks like, but can you try something like below if it works?

Test Ranking2 = VAR test = Table[Slicer] RETURN RANKX ( ALL ( Table[IsoCode] ), CALCULATE ( IF ( CONTAINSSTRING ( test, "%" ), VALUE ( SUBSTITUTE ( test, "%", "" ) ), IF ( CONTAINSSTRING ( test, "$" ), VALUE ( SUBSTITUTE ( test, "$", "" ) ), BLANK () ) ) ), , ASC )

topic Re: RANKX returns 1 for all ISO Codes in DAX Commands and Tips

RANKX returns 1 for all ISO Codes

Re: RANKX returns 1 for all ISO Codes