Irina
December 2, 2020, 6:32pm
1
Hi team.
Hope you are all well.
I am trying to figure out the DAX for the following case (also see attached):
Count the Raised but Not Cleared and Verified orders (where the cell has a date as value)
Count the Raised and Cleared but not Verified orders
question on edna forum.pbix (73.8 KB)
Thank you in advance. Appreciate your help.
regards, irina
@Irina
Try the following:
Raised and Cleared but not Verified =
CALCULATE (
COUNTROWS ( 'Project Data' ),
FILTER (
'Project Data',
'Project Data'[Raised Date] <> BLANK ()
&& 'Project Data'[Cleared Date] <> BLANK ()
&& 'Project Data'[Verified Date] = BLANK ()
)
)
Raised but not Cleared & Verified =
CALCULATE (
COUNTROWS ( 'Project Data' ),
FILTER (
'Project Data',
'Project Data'[Raised Date] <> BLANK ()
&& 'Project Data'[Cleared Date] = BLANK ()
&& 'Project Data'[Verified Date] = BLANK ()
)
)
question on edna forum.pbix (73.8 KB)
Thanks.
3 Likes
Irina
December 2, 2020, 7:45pm
3
MudassirAli:
Raised but not Cleared & Verified =
CALCULATE (
COUNTROWS ( 'Project Data' ),
FILTER (
'Project Data',
'Project Data'[Raised Date] <> BLANK ()
&& 'Project Data'[Cleared Date] = BLANK ()
&& 'Project Data'[Verified Date] = BLANK ()
)
)
Awesome. It did work. Thank you for quick reply.
1 Like