topic Re: Rankx is not working count in DAX Commands and Tips

Rankx is not working count

Anonymous — Sat, 30 Jan 2021 18:06:14 GMT

Hello,

I have created the following measures, but what I get is not what I am expecting. I can fix the problem but changing the all function for

ALL('Reporte de incidencias'[Seller] ) the reason why I dont what this is since I would like to my top N by seller, store and so on so I'd rather not create a measure for each column. I have seen videos where they just type the table and it works just fine please help

Count_inc = COUNTROWS('Reporte de incidencias')

rank = RANKX(ALL('Reporte de incidencias' ),[Count_inc],,DESC)

Re: Rankx is not working count

mahoneypat — Sat, 30 Jan 2021 19:02:12 GMT

Since you don't likely have a single row for each seller in that table, you will not get the expected behavior. I think you will need separate measures for your different scenarios (when different columns in the table), or have them all as variables and choose from them with ISINSCOPE, etc.. If you will have those 3 columns, you can use ALL( ) with all 3 in it.

Pat

Re: Rankx is not working count

Anonymous — Sat, 30 Jan 2021 19:05:42 GMT

I never heard of isinscope. Could you please write an example with column seller and store please

Re: Rankx is not working count

mahoneypat — Sat, 30 Jan 2021 19:12:45 GMT

I don't recommend that approach. You would be writing mulitple variables each with a different RANKX expression. Writing a Rankx measure for each scenario is simpler.

Pat