Forum Discussion

smpa01's avatar
smpa01
Community Champion
4 years ago
Solved

DAX to filter table based on TOPN aggregation

I have a table like this   | name | sale | |------|------| | a | 1000 | | a | 1500 | | b | 2000 | | b | 1500 | | c | 2000 | | c | 2000 | | d | 5000 |   and I am trying ...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

smpa01 you can also do this:

 

Top Name = 
CALCULATE ( 
    [Sum Sales], 
    KEEPFILTERS (
        TOPN ( 
            2, 
            ALLSELECTED ('Top'[name] ), 
            [Sum Sales], 
            DESC 
        )
    )
    //VALUES ('Top'[name] ) 
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

smpa01 ^^ This is exactly what I would have suggested.