Forum Discussion

Redraidas1's avatar
Redraidas1
Helper I
5 years ago
Solved

How to get TOP10

I'm trying to limit my DAX top give me the the SUM of TOP10 sales, however, DAX seems to be ignoring my TOP10 request and won't limit the caluclation to TOP 10 only. Any ideas? Thanks!   CALCULATE...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Redraidas1 ,

     

    You could consider to create a measure using RANKX() function.

    Then add this measure to filter to filter the data that rank value is less than 10.

    For example:

    _sum = SUM('Table'[value])

_rank = RANKX(ALL('Table'),[_sum])

     

     

    Best Regards,

    Jay

VijayP's avatar
VijayP
Community Champion
5 years ago

Redraidas1 

Use this Function
VAR = RankofABC = Rankx(all(AfterSales_BM[ColumnName]),sum(abcvalue))
return
calculate(sum(abcvalue),filter(all(all(AfterSales_BM[ColumnName]),RankofABC<=10),distinct(columname))