Top N does not work correctly

[krzysztofpiotro]

Hi,

I am facing some problem with Top N filter. I am trying to compose a visual showing top 7 employee by sum of CzasGodziny. But the result returns much more rows... See pics below. There are no ties between 7th and 8th row, so I have no idea what's happening. If I put top 10 or top 15 filter, the result still does not return correct number of rows.

Could anyone tell me what would be the reason? It behaves similarly also for other coulmns, nevermind if they are of integer or real data type.

Thanks in advance for any help!

[v-jiascu-msft]

Hi @krzysztofpiotro,

Can you share the file? Please mask or delete the sensitive parts first.

1. It seems the Visual Level filter. Did you apply it in the left table?

2. Please also upgrade to the latest version of Desktop.

Best Regards,

Dale

[krzysztofpiotro]

Hi,

Thanks for reply. I have sent you the file - see private message.

Regarding questions:

1. Yes, this is Visual Level Filter applied to the depicted table and it does not work correctly.

2. Unfortunately, upgrade to the newest version did not help.

[v-jiascu-msft · Accepted solution]

Hi @krzysztofpiotro,

The result is expected. It has duplicates. Maybe the result on the right is what you want. Any other requests, please feel free to input here.

Best Regards,

Dale

[jatneerjat]

Hi @v-jiascu-msft 

I also have same problem I want top 100 apps based on number of users for each app but as the number of users are same for many apps so it is giving 400 apps instead of 100 so how can i get 100 apps whether the apps have duplicate or not?

[krzysztofpiotro]

Yes! This is the result I wanted to reach. Thank you very much 🙂