error with IF statement

[Anonymous]

Dear, 

I have a problem with the IF statement like this. How could I adjust to be right? 

Hope you could help me!!

Thanks !! 

[MFelix · Accepted solution]

Hi @Anonymous 

Your issue in the formula is based on the part where you are making the comparision between two values:

300 <    [Net Value]  < 700

In DAX this is not acceptable, you need to redo your measure, also instead of making IF within IF you should use the SWITCH measure that evaluates an expression against a list of values and returns one of multiple possible result expressions.

Try to redo your formula in the following way:

Net Value Level =
SWITCH (
    TRUE ();
    [Net Value] < 100; "<100";
    [Net Value] < 300; "<300";
    [Net Value] > 300
        && [Net Value] < 700; "700";
    [Net Value] > 700
        && [Net Value] < 1000; "1000";
    ">1000"
)

Regards,

MFelix

[Anonymous]

Dear, 

Thank you for solution and spending time to help! 

it works perfeclty!!