Forum Discussion

DtMatt's avatar
DtMatt
New Member
2 years ago
Solved

Count across multiple columns

Hi everyone,

Can someone help with this one please?

 

If I have various columns of data in Excel and in Power-Bi I need a measure (or new column) that counts all the 'Outstanding' rows across the 9 different columns and shows the total.

For example: Outstanding = 22

 

How can I do this?

 

Thanks 🙂 

 

 

Need Help

10 Replies

  • DtMatt's avatar
    DtMatt
    New Member
    2 years ago

    When I use this... it only shows the total as 4, when it should be 13

     

    Measure =
      COUNTROWS(
        FILTER(
          'IT Progress Data',
          [202 Last Activitiy] = "Outstanding" && [203 Last Activitiy] = "Outstanding"
         )
      )
    • DtMatt's avatar
      DtMatt
      New Member
      2 years ago

      Thanks Ahmedx 

      I have other columns in the data that are feeding other visuals, so when I unpivot the columns, all other visual break.

      Any ideas?

      • Ahmedx's avatar
        Ahmedx
        Super User
        2 years ago

        select these columns together and unpivot the other columns and then you don’t need to add a column index