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

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

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?