Need to get the maximum value of one column, in relation to the values of other column

[LuisNC]

Hello guys,

I'm starting my journey in Power BI.

I have these 2 columns:

The tables are connected via the item_code column. Comsumer Price Index belongs to the CPIData Table.

I need to find out what is the item name with the highest consumer price index.

Could you please help?

[LuisNC]

@Greg_Deckler  thank you so much for your prompt reply. I'll take some time to understand and try your code 😉 cheers

[Greg_Deckler · Accepted solution]

@LuisNC Try something like this in a Card visual:

Measure = 
  VAR __HighestPrice = MAX('CPIData'[Consumer Price Index])
  VAR __ProductCode = MAXX(FILTER('CPIData',[Consumer Price Index] = __HighestPrice),[item_code])
  VAR __Item = MAXX(FILTER('CPIItem', [item_code] = __ProductCode),[item_name])
RETURN
  __Item