Column calculated to bring the maximum value if there are duplicate values

[Syndicate_Admin]

I have the following table that has duplicate shipment values, I need that every time I find duplicate shipment values I choose the highest Max Division value.

In this case, the column calculated for the 2 rows shows the value of 3.34239

[Syndicate_Admin]

Thank you very much, it worked out perfectly!.

[Anonymous · Accepted solution]

Hi, @Syndicate_Admin 

Data provided based on your description and pictures:

I use the following calculated column DAX expression:

Column =
CALCULATE (
    MAX ( 'Sheet1'[MAX Division] ),
    FILTER ( 'Sheet1', 'Sheet1'[Shipment_Id] = EARLIER ( Sheet1[Shipment_Id] ) )
)

Here are the results:

I have provided the PBIX file used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.