Where is null

[u16815]

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 · Accepted solution]

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

[SpartaBI]

@u16815 try this:

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

Showcase Report – Contoso By SpartaBI