Forum Discussion

traviscole's avatar
traviscole
Advocate I
5 years ago
Solved

TOPN sorting

I am hardcore failing at making TOPN work in DAX instead of the filters on a visual.  I have tried and looked at a million different things and ways of doing it in my real data set and this dummy sam...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Volume total : =
    SUM(Volume[Volume])

     

     

    Top five volume measure : =
    CALCULATE (
    [Volume total :],
    KEEPFILTERS ( TOPN ( 5, ALL ( Items ), [Volume total :], DESC ) )
    )
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Volume total : =
SUM(Volume[Volume])

 

 

Top five volume measure : =
CALCULATE (
[Volume total :],
KEEPFILTERS ( TOPN ( 5, ALL ( Items ), [Volume total :], DESC ) )
)
 
 
 
  • traviscole's avatar
    traviscole
    Advocate I
    5 years ago

    This appears to be the explanation I was looking for.   I feel really dumb after seeing it, I blame being tired at the end of a day and week.  Will post back in a little after I run it through the real data set.

     

    Update:  It works!  Only problem having now in the real dataset is when I try to use a measure I have built that spits out what I want the TOPN to be (instead of using an actual number) it's funky and goes from sorting the top 95 when I use 'TOPN(95' to sorting the top 25 when I use 'TOPN([measure]' (but still keeps the total at the bottom of the table as the total of TOP95, but only showing TOP25 items, lol.  Gonna do some reading and look into what is up, but I've triple checked the measure and it's spitting out a 95 everywhere else I use it.