Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Helper IV
8 years ago
Solved

RANKX Issue!

Hi!   I have an strange rankx issue. I used to use RANKX measure currently in other work Im doing, but now in this file all RANK im trying to do does not have the expected result. It is very strang...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi AlejandroPCar

     

    Try this MEASURE as a test

    I just replaced ALL( 'TABLA CRUCE'[NIT]).......   with...........  ALL( 'TABLA CRUCE'[NIT],'TABLA CRUCE'[NOMBRE])

     

     

    Rank Dimension Interna =
VAR RankDimension =
    RANKX (
        ALL ( 'TABLA CRUCE'[NIT], 'TABLA CRUCE'[NOMBRE] ),
        [Dimensión Interna],
        ,
        0,
        DENSE
    )
RETURN
    IF ( [Dimensión Interna] = 0, BLANK (), RankDimension )

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi AlejandroPCar

 

This is because you have BLANK "NIT" items which are also RANKED

 

These items are filtered OUT at REPORT LEVEL

 

See the image below

 

AlejandroPCar's avatar
AlejandroPCar
Helper IV
8 years ago

Hi! Zubair_Muhammad

Ok, thanks for your entire help. Im will try how to solve the BLANK problem. Until this point, your solution works excellent. Thanks again. Also, if you have any idea how to overcome this problem its gonna be fine.