Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure Error

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])))))
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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])))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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])))