DAX for MIn/Max based on count

[harshadsp]

Hello All, Need hep!

I need to dispay (on card tile) min and max hour when the count of crime is min and max. Hour is on x axis and crime # on y axis. In this example I need to dispay max time as 2am since count is 170 and min time 20.00 since min crime is 24 on that time.

Could you please advise how do I achieve this? I am thinking to make a column using DAX but not sure the formula in DAX.

Thanks!

[Zubair_Muhammad]

HI @harshadsp

Another way, in case there are'nt more than 1 time with same Count of Maximum Crimes

TimeMaxCrime =
VAR MaxCount =
    MAXX ( VALUES ( Table1[Time] ), CALCULATE ( COUNT ( Table1[Crime Type] ) ) )
RETURN
    CALCULATE (
        VALUES ( Table1[Time] ),
        FILTER (
            VALUES ( Table1[Time] ),
            CALCULATE ( COUNT ( Table1[Crime Type] ) = MaxCount )
        )
    )