topic RANKX with filter start at number 2 in DAX Commands and Tips

RANKX with filter start at number 2

Morrison — Thu, 28 Jul 2022 09:32:45 GMT

Hello,

I want to ask you for help on RANX measurement with filters.

By inserting the measure, the ranking starts from 2 and in some cases jumps one rank.

The formula used is this

Rank Incidenza Gara Comparto 1 = RANKX ( FILTER (ALL( 'dwh DimStore'), 'dwh DimStore'[Region] IN {"X","Y","Z"})

, calculate(sum('Venduto Totale'[Gara_Tot_quantita])/sum('Venduto Totale'[Tot_Scontrini])))

and the result is this

Rank Incidenza Gara Comparto 1	Store	Incidenza Pezzi_Presenze
2	A	61,77%
3	B	56,46%
4	C	54,06%
5	D	51,29%
6	E	47,98%

Thx all

Re: RANKX with filter start at number 2

johnt75 — Thu, 28 Jul 2022 11:23:34 GMT

It seems like there are filters being applied to the table. Use Performance Analyzer to get the DAX code generated for the table and have a look at it in DAX Studio. You could then potentially add those filters into the RANKX so that only those stores are included.

Re: RANKX with filter start at number 2

Morrison — Thu, 28 Jul 2022 13:11:22 GMT

Yes, there are other filters in the table. I followed your advice and added the missing filters. Now everything works correctly.
Thanks 1000 !!!