Forum Discussion
Top N Filter doesn't work (with examples)
Hi everyone¡ due to the good help I received with my previous problem with PowerBI, I have decided to ask for help again. I want to filter the entire page by the Top N Managers...
Yes, sorry for my english it's not good that i would.
The problem is that if i click 5 on this filter:
I only want to see in the table, the top 5 shops/managers with more Aum. If i click 10, i only want to see in the table top 10 managers/shops with more Aum
And the result that this table shows is:
There are all shops/managers in the table (210 more or less). But, Overall value IS CORRECT because that 39.879.306... its the sum of the 5 top shops, but the table shows all shops
PaulDBrown
Community Champion
Community ChampionCan you post the measures you have used to calculate the [Overall Value]? In the example I provided, the rows beyond the selected TopN are blank, so there os something going on in your measures