Forum Discussion

goaltender36's avatar
goaltender36
Helper I
10 years ago
Solved

Countif for multiple rows

Hello,   I am trying to count if there is a valuse in a row. My table has 5 columns some rows have a value and some dont example   column   A   B  C  D  E Row1      0    1   0   0  0  Row2     ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hi goaltender36

     

    CountVal =
SUMX (
    'Table-Count',
    IF (
        'Table-Count'[A] + 'Table-Count'[B]
            + 'Table-Count'[C]
            + 'Table-Count'[D]
            + 'Table-Count'[E]
            > 0,
        1,
        0
    )
)

     

     

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

hi goaltender36

 

CountVal =
SUMX (
    'Table-Count',
    IF (
        'Table-Count'[A] + 'Table-Count'[B]
            + 'Table-Count'[C]
            + 'Table-Count'[D]
            + 'Table-Count'[E]
            > 0,
        1,
        0
    )
)

 

 

goaltender36's avatar
goaltender36
Helper I
10 years ago

Thank you! I think it worked! It gave me the number of rows that had a value in them