Latest Enterprise DNA Initiatives

Countrows with a if statement

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

@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

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

1 Like