DAX Formula that sums the max values

[sas028]

Hi all,

I'm trying to use dax formulas to solve the total of the max value options for certain purchase numbers by supplier. 

Please find example data below:

Supplier Name	Purchase Number	Option	Total base Price
Supplier A	GEO012	Option 1	20
Supplier A	GEO043	Option 1	30
Supplier A	GEO043	Option 2	35
Supplier A	GEO045	Option 1	10
Supplier A	GEO046	Option 1	12
Supplier A	GEO046	Option 2	15
Supplier A	GEO055	Option 1	20
Supplier A	GEO055	Option 2	30
Supplier B	GEO037	Option 1	30
Supplier B	GEO037	Option 2	20
Supplier B	GEO043	Option 1	35
Supplier B	GEO043	Option 2	36

Resulting Formula:

Supplier Name	Max Quote Value
Supplier A	110
Supplier B	66

Essentially what the formula will do for each purchase item the supplier will provide, it finds the max value between option 1 and option 2 and sum those values to find the max sum value. Some suppliers only provide 1 option. 

Hope this makes sense. Any help would be greatly appreciated. 

Thanks! 

[sas028]

That worked perfectly. Thank you! 

[Ahmedx · Accepted solution]

plse try this

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiDyNI_N_kgTJPN1G?e=opJCmD