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

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

 

 

 

 

hoyt22's avatar
hoyt22
Helper I
1 year ago

lbendlin I still want the date slicer to be observed. The Advertiser slicer should just affect what shows in the matrix but not the rankings themselves. Let me know if that isn't clear. I appreciate your help!

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Then you will have to invest in a proper data model, with a calendar table, a Market table, and a Advertisers table.  Not possible to do this all in the same fact table.