Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to make this ISNOT function working

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 ve...
Need Help
Show and Tell
Tips and Tricks
  • edhans's avatar
    edhans
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?