COUNTROWS exclude based on empty value in other column

[VegarOyfoss]

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"

)

[az38 · Accepted solution]

Hi @VegarOyfoss 

try

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

[VegarOyfoss]

@az38 Brilliant. Thank you. That did the trick