If Formula Error

[Anonymous]

Hi Expert

The last if step is not working  ie. its returning back no result when there clearly is a result if i filter my data set... see highlighted section 

Mymeasure =

IF(QUOTEMAN[TRUSTWITHCONSEQ] = 1, "TWC",

        IF(QUOTEMAN[TRUSTWITHCONSEQ] = 0 ,

        IF(QUOTEMAN[FINCNTRL_ACTUALCOST] > 1000000, "VB3",

        IF(QUOTEMAN[FINCNTRL_ACTUALCOST] >= 100000 && QUOTEMAN[FINCNTRL_ACTUALCOST] <= 1000000 , "VB2B",

        IF(QUOTEMAN[FINCNTRL_ACTUALCOST] >= 25000 && QUOTEMAN[FINCNTRL_ACTUALCOST] <= 100000 , "VB2A",

        IF(QUOTEMAN[OPTNCHOICE] = 1,

        IF(QUOTEMAN[OPTTOTALCOST] > 1000000, "VB3",

        IF(QUOTEMAN[OPTTOTALCOST] >= 100000 && QUOTEMAN[OPTTOTALCOST] <= 1000000 , "VB2B",

        IF(QUOTEMAN[OPTTOTALCOST] >= 25000 && QUOTEMAN[OPTTOTALCOST] <= 100000 , "VB2A",

        IF(QUOTEMAN[OPTNCHOICE] = 0,

        IF(QUOTEMAN[QUOTEMANROC] > 1000000, "VB3",

        IF(QUOTEMAN[QUOTEMANROC] >= 100000 && QUOTEMAN[QUOTEMANROC] <= 1000000 , "VB2B",

        IF(QUOTEMAN[QUOTEMANROC] >= 25000 && QUOTEMAN[QUOTEMANROC] <= 100000 , "VB2A","VB1")))))))))))))

[vanessafvg · Accepted solution]

please provide some data that relates with what you are doing as its very hard to tell you whats wrong with only the thing that is wrong.  You need to provide some sample data in text format so that your code can be evaluated against the data.

[Anonymous]

Hi Vanessafvg - i have managed to solve it by add a extra step into a new calculated column. Thanks for looking at my question ...

can you kindly have a look at 
(1) Return max value if ID is the same - smallest valu... - Microsoft Power BI Community

[Anonymous]

Hi Vanessafvg - its restricted i cannot provide any data very sorry.