Counting blanks

[Anonymous]

Hello, 

Need help with the conditional function like where. I want to count requestID where pending audit = blanks.

OMPending QA =

CALCULATE(

COUNTROWS('CA Omega'), 'CA Omega'[Request ID],'CA Omega'[Pending Audit] = BLANK())

But the error said it can't display the visual.

[Anonymous]

OMPending QA =

CALCULATE(

DISTINCTCOUNT(CA Omega'[Request ID]),ISBLANK('CA Omega'[Pending Audit] ))

[Anonymous]

Hello

Try this :

OMPending QA =

CALCULATE(

DISTINCTCOUNT5CA Omega'[Request ID]°,isblank('CA Omega'[Pending Audit] ))

[Anonymous]

Hi, the CA Omega'[Pending Audit] turns grey

[tamerj1]

Hi @Anonymous 
Please try

Number of Blank =
CALCULATE ( COUNTROWS ( 'CA Omega' ), 'CA Omega'[Pending Audit] = BLANK () )

[Anonymous]

Yah it works, but the thing is I want to depend it to requestID. Is it possible? Because my total request ID's that was blank is 113 and this code returns 115 rows 

[tamerj1]

@Anonymous 
Not sure what do you mean but I gues you're looking for either 

Number of Blank =
CALCULATE ( COUNT ( 'CA Omega'[Request ID ), 'CA Omega'[Pending Audit] = BLANK () )

or

Number of Blank =
CALCULATE ( DISTINCTCOUNT ( 'CA Omega'[Request ID ), 'CA Omega'[Pending Audit] = BLANK () )

Otherwise please provide one example

[Anonymous]

Hello,

My table name is CA Omega and Request ID and Pending Audit are my columns.
The thing is, i want to count RequestID that was blank in Pending Audit, i dont want to count Pending Audit alone because it also count my excel's blank item. Its like count RequestID where Pending Audit = blank.

[Anonymous · Accepted solution]

Hi, I think i got it

OMPending QA =

CALCULATE (

COUNT ( 'CA Omega'[Request ID] ),

FILTER ( 'CA Omega', 'CA Omega'[Pending Audit] = BLANK () )

)
But thanks tho!