Forum Discussion

dataconsole's avatar
dataconsole
Frequent Visitor
3 years ago

TOP N Formula as TOP N integrated filter

Dear members,   Is it possible to write a formula with TOPN that works the same way than integrated TOPN Filter in the Filter Pane ?   - When i use the Filter Pane with TOP N, it's possible to sh...
Need Help
Tips and Tricks
dataconsole's avatar
dataconsole
Frequent Visitor
3 years ago

Hi Mikelytics 

 

as i said i was searching for the formula which was achieving the same result than the TOPN function from filter pane.

 

Thanks for the workaround though 

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi dataconsole 

     

    Please find below the formula:

     

    Top10 Customers = 
TOPN(
   10,
   ALL(Table),
   [Expression] 
)

     

     

    This formula gives back the top 10 but you wont be able to put it in a visual because visuals can not give back calculated tables.

     

    Please find more infromation under:

    TOPN function (DAX) - DAX | Microsoft Learn

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.