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 Omega'[Pending Audit] = BLANK())
But the error said it can't display the visual.

 

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!

8 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 
    Please try

    Number of Blank =
CALCULATE ( COUNTROWS ( 'CA Omega' ), 'CA Omega'[Pending Audit] = BLANK () )
    • 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

     

    Try this :

    OMPending QA =
    CALCULATE(
    DISTINCTCOUNT5CA Omega'[Request ID]°,isblank('CA Omega'[Pending Audit] ))
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    OMPending QA =
    CALCULATE(
    DISTINCTCOUNT(CA Omega'[Request ID]),ISBLANK('CA Omega'[Pending Audit] ))