TOPN 1 not working when result has more than one value returned?

[jd8766]

I have a dax query to get me the highest category in a table based on a measure, it is like the below..

Most Common Day =

    TOPN (

        1,

        ALLNOBLANKROW(DimDates[Day_Name]),

        [Cases],DESC)

However this fails if their are days_names with the same number of cases on the day..

Does anyone know a workaround I can put in my measure to avoid this from happening?

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Most Common Day = CONCATENATEX(TOPN(1,ALLNOBLANKROW(DimDates[Day_Name]),[Cases],DESC),DimDates[Day_Name],", ")

Hope this helps.