Filter cannot affect Ranking

[AlejandroPCar]

Hi, 

I need some help here. When I finally get a measure that can allows me a correct ranking, that measure does not work when any of my slicers try to affect it (except date slicer), the result is a rankign with the general rank positions. I tried some solutions with no result. 

Here is like a good rank looks

Here is when slicer runs

Im not sure where is the problem. How can I transform my measure to allow me do good ranking in slicer filtering? Hope you can help me. Here is my pibx file:  https://1drv.ms/u/s!AtTnrgPUQzQCt38y4Y7DG0AxlTsJ

Have a nice day, thanks a lot. 

Alejandro

[parry2k]

in rank expression, use ALL(TableName) to remove any filter applied to the table.

[AlejandroPCar]

Hi, @parry2k

It does not works in my measure. 

[parry2k]

I probably have to download pbix file to take a look. 

[parry2k]

Which slicer you uses that you ranking is changing?

[parry2k]

Rather the question I would like to ask, how you want to rank your data? Based on what?

[AlejandroPCar]

Hi @parry2k

In this particular case the rank is ranking every company (NIT) based of the amount of incomes (Ingresos Operacionales). And well, every slicer I use (except for the date "Periodo Promedio" ) change the rank. 

[parry2k]

so you want rank to be changed when value in slicer is selected but ignore "periodo promedio" slicer, is this correct understanding?

[AlejandroPCar]

Hi @parry2k

No, in fact if you see Periodo Promedio is the only slicer that when you filter the rank still does a good ranking.

The other slicers when you use it make the rank use the total positions like this image.  Ff you use any of the slicers the rank is broken and this happens, Id would like i.e. if I have 13 companies when I filter so the Rank only will go from 1 to 13. 

[v-ljerr-msft]

Hi @AlejandroPCar,

Could you try the formula below to see if it works in your scenario? 

Rank Ingresos Operacionales = 
VAR Ranking =
    RANKX (
        CROSSJOIN (
            ALLSELECTED ( 'Tabla Cruce' ),
            ALLSELECTED ( 'Sectores CIIU Codigos'[Sector] )
        ),
        CALCULATE (
            [Ingresos Operacionales],
            ALLEXCEPT ( 'Tabla Cruce', 'Tabla Cruce'[NIT] )
        ),
        ,
        DESC,
        DENSE
    )
RETURN
    IF ( [Número Empresas Sector] = 0, BLANK (), Ranking )

Regards