Forum Discussion
Impactful IndividualBlank() counts zeroes?
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]))
Impactful IndividualI 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
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