multiple IF issue on DAX

[Anonymous]

I currently have several columns in powerbi:

    'Dates réelles'[Promesses réelles]
    'Dates recalées'[date agrement obtenu recalées]
    'Dates recalées'[date signature de os recalées]
    'Dates recalées'[date reception operation recalées]

and i want to obtain this:

which is approximately :

 - `formule 1` = IF `[Promesse réelles]` > `Today`;  1 ; 0
 - `formule 2` =  IF  `formule 1`= 0 and  `date agrément obtenu  recalées` > `Today` ; 1 ; 0
- `formule 3` = IF formule 2 = 0 and  `date signature de os recalées` > `Today` ; 1 ; 0
- `formule 4`    = IF formule 3 = 0 and `date reception opérations recalées` > `Today` ; 1 ; 0

There is a lot of blank cells so i have to considerate it  


But i can't figure how to create  my If function

I tried:

    formule 1  =
    IF(NOT(ISBLANK('Dates réelles'[Promesses réelles]>TODAY()),1,0
    ))

but i have some error messages and its not working

Do you have an idea?

[Anonymous]

Thank you for your answer,

How can i obtain the count of the "1" results, considering its a calculated column?

[ValtteriN]

Try using SUMX. So something like: 
SUMX(Dates réelles,IF('Dates réelles'[Promesses réelles]>TODAY(),1,0))

[ValtteriN]

Hi,

Since BLANK will always be smaller than TODAY() you don't need ISBLANK and NOT. So try something like this:
    formule 1  =
    IF('Dates réelles'[Promesses réelles]>TODAY(),1,0)


 I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/