Forum Discussion

elnaggar's avatar
elnaggar
Frequent Visitor
8 years ago
Solved

Top N Behavior

Hi All,    I have a table in power BI desktop which I filter with the TOP N method, i get results of 11 rows instead of 10.   I would like to understand how does it apply this, the data does have...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi elnaggar,

     

    TOPN function used to return top 'X' rows which defined in current function. It not contains any remove duplicate features.

     

    Notice:
    1. Sort effect will not available if you try to return all rows from specific table.(maximum amount current row count -1)
    2. You can add filter or other options to parameter table to remove duplicate records.(filter, summarize, distinct...)

     

    Reference:

    TOPN Function (DAX)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi elnaggar,

 

TOPN function used to return top 'X' rows which defined in current function. It not contains any remove duplicate features.

 

Notice:
1. Sort effect will not available if you try to return all rows from specific table.(maximum amount current row count -1)
2. You can add filter or other options to parameter table to remove duplicate records.(filter, summarize, distinct...)

 

Reference:

TOPN Function (DAX)

 

Regards,

Xiaoxin Sheng