Top N values including Ties

[Rishabh-Maini]

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 format. 

I DO NOT want a table with two values. I want to display a card with these two values separated by a comma. (and so on and so forth if there are 3 days with the same sale amount), something like this:

Is this possible in Power BI at all?

Thanks!

[DataInsights · Accepted solution]

@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

[Rishabh-Maini]

@DataInsights 
You, are a blessing. 
Thank you so much!

While here, could you suggest any websites/sources where I can learn/practice/explore DAX measures (instead of only working on them when a requirement rolls in)? Would really appreciate it. 

[DataInsights]

@Rishabh-Maini,

Check out these sites:

https://www.sqlbi.com (check out their book "The Definitive Guide to DAX")

https://enterprisedna.co

https://radacad.com

DAX is a tricky language that requires a conceptual understanding. Invest the time necessary to learn concepts, and measures will flow more easily. 🙂

[Rishabh-Maini]

@DataInsights Thanks once again!