Forum Discussion
Solved
Top N shows more rows than expected
Hi I'm having troubles using Top N to show only the first 10 rows, I know that it works as expected and returns the first 10 values based on the measure. In my case it returns 18 rows. My dat...
Hi N4gash ,
Please try below steps:
1. below is my test tableTable:
2. create measure with below dax formula
Sum_winners = SUM('Table'[Winners])Measure = VAR tmp = CALCULATETABLE ( VALUES ( 'Table'[Name] ), TOPN ( 10, ALL ( 'Table' ), [Sum_winners], DESC ) ) VAR _name = SELECTEDVALUE ( 'Table'[Name] ) RETURN IF ( _name IN tmp, 1 )3. add a teable visual with fields and measure, add a measure to visual filter pane and apply
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
Super UserHi,
There's a tie. Hence you see more than 10 rows. If you want to see only 10 when there are ties, then which 10 do you want to see?