Forum Discussion
ovetteabejuela
Impactful Individual
Impactful IndividualBlank() 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 particula...
ovetteabejuela I hope this post will help.
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]))
parry2k
Super User
Super Userovetteabejuela I hope this post will help.
- ovetteabejuela
Thanks parry2k, we are just 4 seconds away from resolving... hahaha. but thanks for that link... it's very helpful to know those facts.