Concatenate Rank Measure and Column

[Rylee]

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!

[Anonymous]

Hi @Rylee,

Can you please share some sample data to test?

Regards,

Xiaoxin Sheng