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

 

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