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

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