Forum Discussion

u16815's avatar
u16815
New Member
4 years ago
Solved

Where is null

Hello, fairly new to Power BI and only  just started creating DAX measures!

I have created the measure below 

 

Open Incidents = CALCULATE(COUNT(tincidents[CreatedDate]))

 

But I need to add a where clause which is basically Where tincidents[ClosedDate] is null but cant work it out!

 

Thanks

  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    Hi u16815,

     

    If you still have problems on it, please try this Measure.

     

    Open Incidents =
CALCULATE (
    COUNT ( 'tincidents'[CreatedDate] ),
    FILTER ( 'tincidents', ISBLANK ( 'tincidents'[ClosedDate] ) )
)

     

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun

2 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    Hi u16815,

     

    If you still have problems on it, please try this Measure.

     

    Open Incidents =
CALCULATE (
    COUNT ( 'tincidents'[CreatedDate] ),
    FILTER ( 'tincidents', ISBLANK ( 'tincidents'[ClosedDate] ) )
)

     

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun