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 ) )
    )
     
     
     
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

If you check the documentation for TOPN (here and/or here), you may notice that it returns a table as its output, not a single value. A measure can only return a single value.

 

The easiest approach is usually to use the Top N filtering option in the filter pane.

 

See here too: https://community.powerbi.com/t5/Desktop/TopN/m-p/131646

traviscole's avatar
traviscole
Advocate I
5 years ago

Yeah, that's the easy way for us people in the office to do it.  The goal is to make it go automatically by another measure that I have built to spit out a number for what I want the TOPN to be so on the user side they don't have to do anything and break the report or do god knows what.  I wish in that TOPN i nthe filter pane I could just drag in the measure instead of having to manually input the number, but it is what it is.