Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Syndicate_Admin
Administrator
Administrator

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.

Tabo_1-1674568742206.png

I would appreciate your comments.

1 REPLY 1
amitchandak
Super User
Super User

@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))

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors