Countrows with a if statement

DAX DAX Calculations
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

Skjermbilde question on edna forum.pbix (73.8 KB)

Thank you in advance. Appreciate your help.
regards, irina

2

@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 ()
    )
)

1
1729×241 3.11 KB

question on edna forum.pbix (73.8 KB)

Thanks.

3 Likes
3

Awesome. :smiley: It did work. Thank you for quick reply.

1 Like