Measure with an if statment??

[Snowy34]

Good morning all,

I'm bit new to this and I was hoping someone could give me some help with the below issue I have.

I got a simple measure and this works fine but I need to add an IF statement to it, what I need it to do is the following,

IF the answer to the below measure is more then [Prime Shelf] value report 0 and if its less report that value. Could someone please show me how to do this.

Free Prime Shelfs =

[Prime Shelf] - [Used Prime Shelf]

Regards 

[Anonymous · Accepted solution]

Hi @Snowy34 

Free Prime Shelfs =
VAR _ANSWER = [Prime Shelf] - [Used Prime Shelf]
RETURN
IF(_ANSWER > [Prime Shelf], 0, _ANSWER)

Cheers!
A

[Snowy34]

Hi mate,

Just tried that and it just returned the same number as before. In this case, the return value should have been 0

Still showing as -108

[v-piga-msft]

Hi @Snowy34 ,

Have you solved the problem?

If you have solved the problem, please always always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share the data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

Hi @Snowy34 

Give more info.

It is hard to determine whats wrong according to pieces of information.
But, according to the screenshot below, 'used prome shelf' is 470?
So the calculation is correct. Myabe I got the '>' sign wrong? try using '<' insteaad.

Cheers!
A