Forum Discussion

VegarOyfoss's avatar
VegarOyfoss
Icon for Helper II rankHelper II
6 years ago
Solved

COUNTROWS exclude based on empty value in other column

Hi Guys

 

I have a table like this:

 
VAValue
va3
va 
not.vaname
va3
not.va5
 
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"
)

 

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Hi VegarOyfoss 

    try

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

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi VegarOyfoss 

    try

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