Correct data not showing in a Table Power Bi

Question

The first image shows the data without any filter. It is accurate and shows the sales person with their information properly.

2nd image shows after applying the filter. The data is not correct as it shows Van as top in all the geographies even though he is not(as shown in the first image).

The final image shows the data after applying filter + the slicer button. The results are accurate.

Can someone explain the reason and provide the solution.

jgeddes · Answer

I think it is due to how the 'Amount Per Box' measure is written along with the addition of the 'Geo' column to your table visual.&nbsp;
If you were to remove the 'Geo' column from your table would the TOP N filter then provide the result you are expecting?
Consider this example.
With this very simple table

I have the 'Value Sum' measure that is a sumx measure adding the value column of my table, nothing else.
When I apply a TOP N filter to this table on the 'Item' column the top value I would expect to see would be Item 'B' with the Value Sum of 22.
But what I get is
&nbsp;

I deduce from this that the TOP N filter is taking the complete sum for Item 'A' (42) and ignoring the location context.
If I select Location 'zxc' I will get Item 'B' as the TOP N value.

I hope this helps to describe what you are seeing.
&nbsp;

saud_jilani · Answer

&nbsp;If you were to remove the 'Geo' column from your table would the TOP N filter then provide the result you are expecting?No, it still works exactly like before.Your demonstration and conclusion is correct, but it does not provide me the solution to it. I believe there should be a solution to it.