Forum Discussion
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...
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!
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.