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!
