Wrong data is shown when slicer applied

[Yagiz]

Hi,

I have this model:

flowing from google data to countrycodes on country to alpha 2 codes many to one.

I created a measure like this to create a ranking for sales of 3 months:

When I create a table out of this, it works fine:

Then I created a slicer from the country column in google data table. 

When I select a country, ie the US, the data comes up is wrong; because the US should've been the second by ranking.

Plus, when I create a multirow card, it gets even more messed up if I use that relationship to use full country names instead of iso 2 codes:

Can someone please help me?

Thanks in advance

[Anonymous]

Hi @Yagiz ,

How is your ranking formula calculated? How about cancelling the relationship between the tables? Could you please provide more details?

How to Get Your Question Answered Quickly 

Please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yagiz]

Even without using cross table filters, it produces wrong result: