I'm getting count wrong

[Anonymous]

Hi 

I'm pulling the data for two columns and for column1 from one table it is sum and column 2 is from another table it is the count. For these two tables I have another table and I'm giving relation ship between these two tables. But It is many to many relation ship .

Here is the sample data 

column1      column 2           id

argentina      --

brazil

spain

italy

swizerland  

                     6716               509

Here is the problem when I'm giving the filter for above visual for column 2 I'm getting right count but I'm getting wrong count for id i.e 504 I don't know what i'm missing 

[v-lili6-msft]

hi, @Anonymous 

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin

[Anonymous]

The problem has not solved

[v-lili6-msft]

hi, @Anonymous 

Sample pbix file or Sample data and expected output would help tremendously. Just from your description, we couldn't find out the reason.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

and also if it is a measure totals problem.  See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Best Regards,

Lin