Forum Discussion

chahineatallah's avatar
chahineatallah
Helper III
3 years ago

TOP N

Hello Everyone

Just trying some stuff in TOP N Filter

I have a report with ski resorts, so i was doing TOP 5 highest point resorts by country

Now if i choose TOP N BY country, am getting more than 5

But if i choose TOP N by resort i get the correct values, please have a look at sheet 'Top N' to see both versions

Why is the difference, am using explicity measure "Maximum" for highest point, so it should calculate maximum by country and resort isnt?

Please advise why the answers are different https://catallah-my.sharepoint.com/:u:/g/personal/chahineatallah_catallah_onmicrosoft_com/Edmd9uQJ6-JOvBw9E4z7HPYBWcU1juQwpC-uK5DJD_aCTg?e=zm7Ckv 

Thanks

4 Replies