cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovetteabejuela
Impactful Individual
Impactful Individual

Blank() counts zeroes?

Why is this formula counting the zeroes as well:

 

New Measure = CALCULATE(COUNTROWS('Table A'),'Table B'[Data Column]=BLANK())
 
***Table A is related to Table B
 
For example, if a particular criteria has 4 blanks but also had 2 zero-valued data the formula above will return 6 instead of just 4.
2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

@ovetteabejuela I hope this post will help.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

ovetteabejuela
Impactful Individual
Impactful Individual

I think I resolved my own issue and just wanted to share for anyone who cames across this post

 

I simply changed this:

    New Measure = CALCULATE(COUNTROWS('Table A'),'Table B'[Data Column]=BLANK())

to this:

    New Measure = CALCULATE(COUNTROWS('Table A'),ISBLANK('Table B'[Data Column]))

View solution in original post

4 REPLIES 4
ovetteabejuela
Impactful Individual
Impactful Individual

I think I resolved my own issue and just wanted to share for anyone who cames across this post

 

I simply changed this:

    New Measure = CALCULATE(COUNTROWS('Table A'),'Table B'[Data Column]=BLANK())

to this:

    New Measure = CALCULATE(COUNTROWS('Table A'),ISBLANK('Table B'[Data Column]))

@ovetteabejuela I was going to propose to use ISBLANK() but at the same time wanted to share why BLANK() is doing what it is doing.

 

Glad you resolved it.

 

Cheers,

P






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User
Super User

@ovetteabejuela I hope this post will help.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Thanks @parry2k, we are just 4 seconds away from resolving... hahaha. but thanks for that link... it's very helpful to know those facts.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.