Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Icon for Helper IV rankHelper 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 strange becasue as I said before I know this formula and in previous tables it works fine.  

 

In the photo, the marked columns are the RANKX measures and every rank column is for the data at its right side. So, the fist rank column is the rank of the second column (data with font color). Now, I'd like to know what Im doing wrong, I apprecciate your help a lot because it is important to me solve this problem as soon as posible. 

 

Here is my pbix file (sorry but the file is like huge) 

https://1drv.ms/u/s!AtTnrgPUQzQCnAUc2MYHfnad2lPl

 

Thank you again

 

 

 

 

 

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 )

     

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    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 )

     

    • AlejandroPCar's avatar
      AlejandroPCar
      Icon for Helper IV rankHelper IV
      8 years ago

      Hi! Zubair_Muhammad

       

      Thanks a lot for your response. It seems like could work but the rank omitted the number rank number 9. It just pass from 8 to 10, Do you know why this is happening? Even the rank assumes that there are 16 companies but the true number of those is 15. 
      Thank you very much, really. 

       

       

       

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity 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