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 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()))

 

 

 

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.

2 Replies

  • 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.

  • 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?