RANKX with filter start at number 2

[Morrison]

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

[johnt75 · Accepted solution]

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.

[Morrison]

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