Rank Issue with lot of filters

[AlejandroPCar]

Hi!

I do not finish understandig RANKX beacuse Im using it but I cant make it rank the things well. In this scenario I have several filters and I need every filter I aplied the rank so... ranks the selected thing.  I know I got help before about RANKX but all their previous solutions didnt get success. 

Here is my pbix file https://1drv.ms/u/s!AtTnrgPUQzQCnAUc2MYHfnad2lPl , sorry but is some huge. 

Thanks for your help. 

[Vvelarde · Accepted solution]

@AlejandroPCar

Hi, try with:

Measure =
IF (
    [Parte 1 Gobierno Corporativo Diferencia] <> BLANK (),
    RANKX (
        ALLSELECTED ( 'Tabla Cruce'[NIT] ),
        CALCULATE (
            [Parte 1 Gobierno Corporativo Diferencia],
            ALLEXCEPT ( 'Tabla Cruce'; 'Tabla Cruce'[NIT] ),
            ALLSELECTED ( 'Sectores CIIU Codigos'[Sector] )
        ),
        ,
        DESC,
        DENSE
    )
)

Regards

Victor

Lima - Peru

[AlejandroPCar]

Hi @Vvelarde

Thabks for your response but your formula does not work, the result is the same I posted. 

[v-chuncz-msft]

@AlejandroPCar,

It would be better to simplify your model and show us the expected result with dummy data.