Forum Discussion

hoyt22's avatar
hoyt22
Helper I
1 year ago
Solved

Issue with RankX in a Matrix - Duplicate Ranks for Differing Values

Hi all,   I have a matrix with Market and Advertiser in the rows, and I want to rank the Advertisers within each Market on different KPIs. This seems straightforward, but I'm getting duplicate rank...
Dax Help
lbendlin's avatar
lbendlin
Super User
1 year ago

link requires access.

hoyt22's avatar
hoyt22
Helper I
1 year ago

lbendlin Apologies! I've fixed the link. Thank you!

    • hoyt22's avatar
      hoyt22
      Helper I
      1 year ago

      lbendlin The only issue I see is that I don't want the rank of the advertiser to change based on the selections in the Advertiser slicer. As you have it, if I only have one advertiser in the market selected, its rank will update to 1. But I'd like it to stay whatever it was as if all advertisers are still included. Does that make sense? I tried changing ALLSELECTED to ALL, but it messed up the ranks.

       

      Thanks for your help!

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Sounds like you want a calculated column instead? Or do you still want the time filter to be observed?