IF AND STATEMENT Measure Power Query

[Anonymous]

I have two columns: 1. predicted precipitation (Table1[Prediction]) and 2. actual precipitation (Table2[Real]) and I want to test 4 conditions:
a. predicted precipitation/observed precipitation
b. precipitation predicted/precipitation not observed
c. precipitation not forecasted/precipitation observed
d. unpredicted precipitation/unobserved precipitation

I tested this measure for option a:
IF(ISBLANK(Table1[Prediction]);BLANK();IF(AND(Table2[Actual] > 0;Table1[Prediction] > 0);0;1))

However, in cases where prediction is 0 and reality is 0.2, the result of the measure is 0, when it should be 1, because only one of the conditions is true.

I can't get over this obstacle.

I thank you in advance for your help.

[serpiva64]

Please,

can you post an exemple of your tables and of expeted results?

[Anonymous]

Thank you in advance for your interest in helping me. This is an example of my values, the result I expect to get and what, with the formula I posted initially, I am getting.

[serpiva64]

Hi,

try this 

P = IF(and('Table'[Column1]>=0,'Table'[Column2]>0),0,1)

(adapt , and columns name to your case)

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Anonymous]

Thanks for the suggestion, but unfortunately it doesn't solve the issue I raised.
If you notice, in the case where the prediction is 0 and the reality is 0.2, the result should be "1" and not "0".

[serpiva64]

Sorry, 

to many 1 and 0!

try this

P = IF(and('Table'[Column1]=0,'Table'[Column2]=0),1,If(and('Table'[Column1]>=0,'Table'[Column2]>0),0,1))

[Anonymous]

Thank you for another suggestion. However, the result is the same. If you notice in the table you shared with me, the result is still "0" instead of "1".

[serpiva64 · Accepted solution]

Hi,

i hope this time it's good (i printed your solution to verify)

P = IF('Table'[Column1]=0,1,If(and('Table'[Column1]>=0,'Table'[Column2]>0),0,1))

[Anonymous]

Thank you once again. I see that in your table, the formula works, but in mine, unfortunately not. I still get 0. I don't understand why.

[serpiva64]

Please post the new formula you are using

[Anonymous]

I already know why it didn't work and it's embarrassing. It wasn't a 0, but a 0.3 the prediction. I apologize for wasting your time. Thank you very much for your help.