Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting blanks

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 O...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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!