Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
@u16815 try this:
Open Incidents =
CALCULATE(
COUNT(tincidents[CreatedDate])
tincidents[ClosedDate] == BLANK()
)
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |