Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago

Rank based on two columns

Hi experts! I know, there have been a lot of posts regarding this, but they have not been useful for me. The objective is to have a ranking based on two columns.   I have a dimension table (Table...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

joshua1990 , Need some data to suggest for column1 and column 2. If they are numbers 

 

Rank1 =
    RANKX ( ALLSELECTED ( 'Table Dim'[Product] ), [Column1]+ [Column2] )


Rank1 =
    RANKX ( ALLSELECTED ( 'Table Dim'[Product] ),calculate( [Column1]+ [Column2] ) )