Forum Discussion
Summary table - column comparison
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.
1 Reply
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
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))
