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:   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 obvi...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi VegarOyfoss 

    try

    VA =
CALCULATE (
COUNTROWS (table1),
table1[VA] = "va",
NOT(ISBLANK(table1[Value]))
)
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]))
)
  • VegarOyfoss's avatar
    VegarOyfoss
    Icon for Helper II rankHelper II
    6 years ago

    az38 Brilliant. Thank you. That did the trick