Return a value depending on a max value in another column

[Anonymous]

Hi,

I am looking at some data regarding earthquakes. I can return the highest Magnitude for the selections made, e.g. 8,2 in magnitude. What I want is to also retrieve the date for when it happened, and the region. So, if I select the month of July and the highest recorded magnitude was outside Japan on 2021-08-12, how can I get that value on a card? Looks like I am not using the correct DAX! Data looks as in the image below, thanks!

Kind regards,

Jari

[Jos_Woolley · Accepted solution]

Hi,

Date/Region Highest Magnitude =
VAR MyTable =
    ADDCOLUMNS (
        'Table 1',
        "Concat",
            'Table 1'[Date] & "|" & 'Table 1'[Region Name]
    )
RETURN
    MAXX (
        MyTable,
        IF ( 'Table 1'[Magnitude] = MAX ( 'Table 1'[Magnitude] ), [Concat] )
    )

Regards

[Anonymous]

Thank you, it works well with minor changes since it was supposed to be split!

Kind regards,

Jari