Count across multiple columns

[DtMatt]

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 🙂 

[Ahmedx · Accepted solution]

[Ahmedx]

to know how to do this watch my video

40.mp4

[DtMatt]

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]

I can give a different solution without unpivot but it will be a not good practice

[Ahmedx · Accepted solution]

[DtMatt]

Yes, this one worked.

Thanks @Ahmedx 

[Ahmedx]

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

[Ahmedx]

[DtMatt]

So because I'm using these columns in other visuals, when I unpivot, I get this:

[Ahmedx · Accepted solution]

try this

[DtMatt]

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"

     )

  )