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.

edhans's avatar
edhans
Community Champion
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.