cancel
Showing results for
Did you mean:  Helper I

## COUNTROWS exclude based on empty value in other column

Hi Guys

I have a table like this:

 VA Value va 3 va not.va name va 3 not.va 5

Currently I have a meassure which calculates total rows with va, and this obviously give a total of 3
VA =
CALCULATE (
COUNTROWS (table1),
table1[VA] = "va"
)

However, I also want to calculate so that it does NOT count when Value column is empty. So in example above it should give total of 2

I know that the below would count everytime VA is va and Value is 3, giving a count of 2, but I am not able to figure out how to do it to exclude when [Value] is empty

VA =
CALCULATE (
COUNTROWS (table1),
table1[VA] = "va",
table1[Value] = "3"
)

1 ACCEPTED SOLUTION  Community Champion

try

``````VA =
CALCULATE (
COUNTROWS (table1),
table1[VA] = "va",
NOT(ISBLANK(table1[Value]))
)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution
2 REPLIES 2  Community Champion

try

``````VA =
CALCULATE (
COUNTROWS (table1),
table1[VA] = "va",
NOT(ISBLANK(table1[Value]))
)``````

do not hesitate to give a kudo to useful posts and mark solutions as solution  Helper I

@az38 Brilliant. Thank you. That did the trick  