Forum Discussion
Correct data not showing in a Table Power Bi
Super UserI 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.
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
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.
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.