DAX Measure Error

[Anonymous]

Hi Experts

I am not getting back a value for the last step of the following dax Calculated Columns measure..is my measure correct... (see bold) or is there a better way to re-write this...i am look for 90k in my visual... 

VRoM/Budget Estimate =

        IF(QUOTEMAN[TRUSTWITHCONSEQIMS] = 1 && QUOTEMAN[OPTNCHOICE] = 0, QUOTEMAN[OPTTOTALCOST],

        IF(QUOTEMAN[TRUSTWITHCONSEQIMS] = 0 && QUOTEMAN[OPTNCHOICE] = 1, QUOTEMAN[OPTTOTALCOST],

        IF(QUOTEMAN[TRUSTWITHCONSEQIMS] = 0 && QUOTEMAN[OPTNCHOICE] = 0, CALCULATE(MAX(QUOTEMAN[OPTTOTALCOST]),ALLEXCEPT(QUOTEMAN,QUOTEMAN[IMSTASKID])))))

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

Switch(True() ,
QUOTEMAN[TRUSTWITHCONSEQIMS] = 1 && QUOTEMAN[OPTNCHOICE] = 0, MAX(QUOTEMAN[OPTTOTALCOST]),
QUOTEMAN[TRUSTWITHCONSEQIMS] = 0 && QUOTEMAN[OPTNCHOICE] = 1, MAX(QUOTEMAN[OPTTOTALCOST]),
QUOTEMAN[TRUSTWITHCONSEQIMS] = 0 && QUOTEMAN[OPTNCHOICE] = 0, CALCULATE(MAX(QUOTEMAN[OPTTOTALCOST]),ALLEXCEPT(QUOTEMAN,QUOTEMAN[IMSTASKID])))