How to add a column with the most expensive part for each product

[ateebagy]

I have a list of products, their parts and the price of the parts. The data looks like this:

Product	Part Number	Price
A	A178	5
A	A179	7
A	A172	10
B	B160	5
B	B165	9

I have another query with the list of products and I want to add a column for the most expensive part for each product. It would look like this:

Product	Most Expensive Part Number	Most Expensive Part Price
A	A172	10
B	B165	9

[v-yuta-msft]

Hi ateebagy,

Create a calculate column using DAX like below:

Most Expensive Part Price =
CALCULATE (
 MAX ( Table1[Price] ),
 FILTER ( Table1, Table1[Product] = EARLIER ( Table1[Product] ) )
)

  

Then you can create a table chart and create a slicer chart as below to achieve your requirement:

Regards,

Jimmy Tao