Forum Discussion

Rylee's avatar
Rylee
Helper I
9 years ago

Concatenate Rank Measure and Column

I have a measure that uses the RANKX function to return the rank of Brands by DisplayMeasures. I want to concatenate this rank number with the [Brand] column. When I have the measure on its own, it returns 1, 2, 3, 4, etc.

 

RankSelected = Rankx(ALLSELECTED('T_Final Brand Table'), [DisplayMeasures], , DESC)

 

 

If I put this in a calculated column, I have to specify the [Brand] column or there is a circular dependency. When I use the following function, the RANKX function returns 1 all the way down, so it looks like 1brandnameA, 1brandnameB, 1brandnameC etc.

 

Column = Rankx(ALLSELECTED('T_Final Brand Table'[Brand]), [DisplayMeasures], , DESC) & 'T_Final Brand Table'[Brand]

 

 

Can someone tell me if it is possible to concatenate the two with the correct ranking?

 

Thanks!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Rylee,

     

    Can you please share some sample data to test?

     

    Regards,

    Xiaoxin Sheng