RANKX measure Worked in Table 1 but Not in Table 2

[Anonymous]

Hello everyone,

I am encountering a challenge in Power BI related to ranking phone brands by the number of installs using RANKX. My measure [Rank Device Installs] functions correctly in Table 1.

However, when applying a visual filter in Table 2—specifically, filtering [Count Device Install] to be greater than 0—the ranking does not work as expected ([Rank Device Installs] returns 1 for ALL Phone Brands)

How can I ensure that [Rank Device Installs] works correctly in Table 2 when the visual filter is applied?

Additionally, as a bonus question, I would like the "Other" phone brand to always be ranked the lowest, even though it consistently has the highest number of installs. How can I modify the ranking logic to achieve this?

I have attached a sample file and would appreciate any guidance. Thank you!

https://drive.google.com/file/d/16HprjYeDa1YQD8bzME_UOrtXvbGSe51i/view?usp=sharing

[Greg_Deckler · Accepted solution]

@Anonymous This should fix the filtering issue:

 RANKX(

    ALLSELECTED(Sheet3),

    CALCULATE([Count Device Install], ALLEXCEPT('Sheet3', Sheet3[Phone Brand]) ), , DESC, Dense

 )

[Anonymous]

It worked perfectly, Greg. Thanks!

However, why do you need to explicitly remove filters from everything? Is it because RANKX is also influenced by the visual filter on [Count Device Install]?

[Greg_Deckler]

@Anonymous Yeah, honestly, this was a new and weird one for me. I'm not even sure why RANKX is being weird like this and I wasn't having much luck with RANK either. So...yuck.