How to make this ISNOT function working

[Anonymous]

Hello, I have those two measured colums which counts the number of logements by a certain date, in the first case i want to keep only rows not null, on the other one i keep all "date promesse de vente réelles" rows

Unfortunetly the result is the same in the both case so i guess the first measured colum isnt working, any idea to fix it?

First measured column = 

Logements par promesse réelle vide =
CALCULATE(
'Opérations'[Nb de logements],
FILTER('Dates réelles', 'Dates réelles'[date promesse de vente réelles]))

Second measured column: 

Logements par promesse réelle non vide =
CALCULATE(
'Opérations'[Nb de logements],
FILTER('Dates réelles', 'Dates réelles'[date promesse de vente réelles] <> BLANK()))

[Anonymous]

Thanks you by a lot!

I have now my 4 measurements that i wanted :

Logements par promesse non vide =

CALCULATE(

'Opérations'[Nb de logements],

FILTER(

'Dates réelles',

NOT ISBLANK( 'Dates réelles'[date promesse de vente réelles] )

)

)

Logements par agréments recalés non vides =

CALCULATE(

'Opérations'[Nb de logements],

FILTER(

'Dates recalées',

NOT ISBLANK( 'Dates recalées'[Agréments] )

)

)

Logements par OS non vide =

CALCULATE(

'Opérations'[Nb de logements],

FILTER(

'Dates recalées',

NOT ISBLANK( 'Dates recalées'[OS / VEFA])

)

)

Logements par réception non vide =

CALCULATE(

'Opérations'[Nb de logements],

FILTER(

'Dates recalées',

NOT ISBLANK( 'Dates recalées'[Réceptions])

)

)

But do you know how i can summ it?
 I tried:

total logements test = 'Dates réelles'[Logements par promesse non vide] + 'Dates recalées'[Logements par OS non vide] = 'Dates recalées'[Logements par agréments recalés non vides]+ 'Dates recalées'[Logements par réception non vide]

But i have for result : "False" and I can't use "SUM" because i have too much measurements to calculate

Any idea?

[edhans · Accepted solution]

Try this:

SomeMeasure =
CALCULATE(
    'Opérations'[Nb de logements],
    FILTER(
        'Dates réelles',
        NOT ISBLANK( 'Dates réelles'[date promesse de vente réelles] )
    )
)

You cannot use <> BLANK() as that will also exclude 0. You can use ==BLANK() if you want to differientate with =0, but I don't know how to do that for not equal, but NOT ISBLANK() works.