cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xRTP
Helper III
Helper III

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.

xRTP_0-1654425291177.png

 

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

View solution in original post

8 REPLIES 8
JamesFr06
Super User
Super User

OMPending QA =
CALCULATE(
DISTINCTCOUNT(CA Omega'[Request ID]),ISBLANK('CA Omega'[Pending Audit] ))
JamesFr06
Super User
Super User

Hello

 

Try this :

OMPending QA =
CALCULATE(
DISTINCTCOUNT5CA Omega'[Request ID]°,isblank('CA Omega'[Pending Audit] ))

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

tamerj1
Super User
Super User

Hi @xRTP 
Please try

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

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 

@xRTP 
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

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.

xRTP_0-1654431224466.png

 

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!

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors