Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

 

 

 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.