Rank issue

[ADP007]

Hi All,

All is ok until I add the URL column to the BOTTOM table (see screen shot). Strange but when I add the LANGUAGE column it works ok. Both columns are from same table.

Any help welcome

PBIX Link 

[ADP007]

Hi does anyone have an idea on how to solve the issue above? Many thanks. 

[ADP007]

hi @amitchandak 

Thanks for your reply and the links. However I still don't know how to solve this. Any idea?

Thanks

David

[amitchandak]

@ADP007 , As Rank(measure), is created on mScoreData, so column from any table will change context and it will change.

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns