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

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors