How do i find a maximum value based on 2 columns?

Hi Anonymous ,

Based on the information you have provided, I can only reproduce part of your requirements, you can provide non-private details or pbix files to achieve your final goal. Depending on the first part of the information you provide, you can follow these steps:

1.Add a measure

Measure =

CALCULATE (

    MAX ( 'Table'[Units Non_Promo] ),

    FILTER (

        ALL ( 'Table' ),

        'Table'[EAN_Item] = SELECTEDVALUE ( 'Table'[EAN_Item] )

    )

)

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

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