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 ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    try this

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

Ahmedx's avatar
Ahmedx
Super User
2 years ago

  • DtMatt's avatar
    DtMatt
    New Member
    2 years ago

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

     

     

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      try this