Forum Discussion

N4gash's avatar
N4gash
Frequent Visitor
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi N4gash ,

    Please try below steps:
    1. below is my test table

    Table:
     

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi N4gash ,

Please try below steps:
1. below is my test table

Table:
 

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.