Forum Discussion

jshumaker's avatar
jshumaker
Frequent Visitor
3 years ago
Solved

ranking from a calculated table

I am trying to add a ranking function to a calculated table but when I do that I get all 1's for the ranking.  Although if I export the data from the matrix to a .csv file, upload the data from the ....
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but please try something like below.

     

    max pct rnk measure: =
RANK (
    skip,
    SUMMARIZE (
        ALLSELECTED ( 'fk01' ),
        'fk01'[column_name_that_shows_100_inthevisual],
        'fk01'[lkey0]
    ),
    ORDERBY ( CALCULATE ( SUM ( 'fk01'[max pct] ) ), DESC ),
    PARTITIONBY ( 'fk01'[column_name_that_shows_100_inthevisual] )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your datamodel looks like, but please try something like below.

 

max pct rnk measure: =
RANK (
    skip,
    SUMMARIZE (
        ALLSELECTED ( 'fk01' ),
        'fk01'[column_name_that_shows_100_inthevisual],
        'fk01'[lkey0]
    ),
    ORDERBY ( CALCULATE ( SUM ( 'fk01'[max pct] ) ), DESC ),
    PARTITIONBY ( 'fk01'[column_name_that_shows_100_inthevisual] )
)