Measure to find value in a column based on MIN value of another column

[AussieClyde]

I have a summary table as per below.

I have the MIN and MAX values of Avg Sales by Season.

I have created a measure to determine the value of Season that corresponds to the MAX value.

But I cannot work out how to create a measure to determine the value of Season that corresponds to the MIN value.

Any help would be greatly appreciated.

[Nathaniel_C · Accepted solution]

Hi @AussieClyde ,

Min season = CALCULATE(min('Table'[SEASON]),Filter(ALL('Table'),'Table'[aVG SALES]= MIN('Table'[aVG SALES])))

I used my own values, but put your table names and column names in and this will work

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[AussieClyde]

Thank you so much @Nathaniel_C - works perfectly!