How to count blanks on this case

[Anonymous]

Hello great Analytics minds:

How can I get the count

SL	Overall Status	Actual Complete Date
1	Completed	6/28/2022
2
3	In-Progress
4
5

Actual date = Blank

Overall status = remove blanks

Appreciate your help. 🙂

Thanks

[Anonymous]

Thank you. Appreciate your help on my learning process.

[selimovd]

Hey @Anonymous ,

I'm happy it works 🙂

Best regards

Denis

[selimovd · Accepted solution]

Hey @Anonymous ,

you can filter the table in measure to blank dates and not blank status. On that filtered table you can use a COUNTROWS measure:

Overal status with Blank Date =
CALCULATE (
    COUNTROWS ( myTable ),
    myTable[Actual Complete Date] = BLANK () && myTable[Overall Status] <> BLANK ()
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic