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

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's avatar
tamerj1
Community Champion
4 years ago

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'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!