Forum Discussion
RANKX Change Measure not working when TopN filter applied
Community ChampionHi kristinamol Your issue is that in first measure, Rank, you used ALLSELECTED and called it in second measure. This is not best practice as results in second measure are hard, almost imposible to interpret/ resolve issue, as second measure calling first measure with ALLSELECTED. The best practice using ALLSELECTED is "just single visual" .
Rework your second measure / find other solution.
Did I answer correctly? Kudos appreciate / accept sokution.
Hi some_bih , could you advise how to rework the Rank Change measure please? I assume it would be along the lines of creating a separate calculated table that holds top 50 topics for the latets month. And then reworking the Rank Change measure to calculate rank change for topics within the calculated table. However, I'm not exactly sure if this is the right approach, so would appreciate guidance on what to do