Summary table - column comparison

[Syndicate_Admin]

Good morning

I have a query, I have a database where a column has data from several products, then I have a second column where the physical state of the inspected component is placed in several zones with the following criteria:

1- Good; 2- Medium; 3-Bad,

Then I have several components that can have several states, I want to get a summary table that shows me the components and their final state.

example

Product A has 3 states (good, medium, bad) but in the summary table it should indicate that A is bad, because that state is more critical despite the fact that there are areas in medium and good state of product A.

I would appreciate your comments.

[amitchandak]

@Syndicate_Admin , Add a new column

rate = left([estado],1)

then follow the measure in

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

example

Last Status = var _max = maxx(filter(ALLSELECTED(Data), Data[Producto] = Max(Data[Producto])), Data[Rate])
return
CALCULATE(max(Data[estado]), filter((Data) , Data[Rate] =_max))