topic Re: how to count a status column with blanks as well in DAX Commands and Tips

how to count a status column with blanks as well

Maz_0102 — Fri, 27 May 2022 09:35:33 GMT

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

Re: how to count a status column with blanks as well

tamerj1 — Fri, 27 May 2022 10:10:31 GMT

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

Re: how to count a status column with blanks as well

Maz_0102 — Fri, 27 May 2022 10:35:58 GMT

thank you replying

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

It should be 38

Re: how to count a status column with blanks as well

tamerj1 — Fri, 27 May 2022 11:03:17 GMT

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

Re: how to count a status column with blanks as well

Maz_0102 — Fri, 27 May 2022 11:12:16 GMT

YOU ARE AMAZING! THANK YOU