Forum Discussion

Helper II

5 years ago

Solved

Top N values including Ties

Hi, I have the following table: I want to display the days with maximum sale, including all days if it is a tie. In the above example, I wish to display "Mon, Thur" in this for...

Need Help

DataInsights

5 years ago

Rishabh-Maini,

Try this measure:

Highest Sale = 
VAR vTable =
    ADDCOLUMNS (
        VALUES ( Table1[Day] ),
        "@Rank", RANKX ( ALL ( Table1[Day] ), CALCULATE ( SUM ( Table1[Sale] ) ),, DESC, DENSE )
    )
VAR vTopValues =
    FILTER ( vTable, [@Rank] = 1 )
VAR vResult =
    CONCATENATEX ( vTopValues, Table1[Day], ", " )
RETURN
    vResult