Forum Discussion

krzysztofpiotro's avatar
krzysztofpiotro
Frequent Visitor
8 years ago
Solved

Top N does not work correctly

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 ti...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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.

    Top_N_does_not_work_correctly

     

     

    Best Regards,

    Dale

krzysztofpiotro's avatar
krzysztofpiotro
Frequent Visitor
8 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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.

Top_N_does_not_work_correctly

 

 

Best Regards,

Dale

  • krzysztofpiotro's avatar
    krzysztofpiotro
    Frequent Visitor
    8 years ago

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

  • jatneerjat's avatar
    jatneerjat
    Helper V
    7 years ago

    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?