how to count a status column with blanks as well

[Maz_0102]

Hello community,

Please i really need your assistance 

I am trying to count a column based on some conditions 

two columns = Status and Uploaded 

I want to count all the data in approved from 'Status' combined with 'No' and blanks from column 'uploaded'

I am trying to use the formula below but the last part of the formual underlined is preventing me from doing it. 

Please can you advise

= CALCULATE(COUNT('Hazard and Near Miss Report'[Type of Hazard]), 'Hazard and Near Miss Report'[Status] = "Approved",'Hazard and Near Miss Report'[Uploaded in 4sight] = "No", 'Hazard and Near Miss Report'[Uploaded in 4sight] = blank())

[tamerj1]

Hi @Maz_0102 

please use

=
COUNTROWS (
    FILTER (
        'Hazard and Near Miss Report',
        'Hazard and Near Miss Report'[Status] = "Approved"
            || 'Hazard and Near Miss Report'[Uploaded in 4sight] = "No"
            || 'Hazard and Near Miss Report'[Uploaded in 4sight] = BLANK ()
    )
)

[Maz_0102]

Hi 

thank you replying 

I have executed this below but the number is not returning correct

It should be 38

[tamerj1 · Accepted solution]

Hi @Maz_0102 
I might have misunderstood your description. Please try

=
COUNTROWS (
    FILTER (
        'Hazard and Near Miss Report',
        AND (
            'Hazard and Near Miss Report'[Status] = "Approved",
            'Hazard and Near Miss Report'[Uploaded in 4sight] = "No"
                || 'Hazard and Near Miss Report'[Uploaded in 4sight] = BLANK ()
        )
    )
)

[Maz_0102]

YOU ARE AMAZING! THANK YOU