Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summarizing multiple columns with counts

I have a database where there is a list of projects in column A, then the following columns are the team members on the different projects.  They are wanting a summary of showing how many projects ea...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    In the Query Editor, select the first column and then select "Unpivot Other columns".  Now you should be able to build your desired visual.

  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi Anonymous.  Your data model doesn't do a great job of supporting this...makes it harder than it needs to be.

     

    In Power Query, unpivot the column for team member so you have a list of {Project A, Member 1}, {Project A, Member 2}, {Project B, Member 2}, {Project B, Member 3}, etc.

     

    From there you could create a matrix visual with Project and then Team Member to give you what you're looking for.

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi Anonymous.  Your data model doesn't do a great job of supporting this...makes it harder than it needs to be.

 

In Power Query, unpivot the column for team member so you have a list of {Project A, Member 1}, {Project A, Member 2}, {Project B, Member 2}, {Project B, Member 3}, etc.

 

From there you could create a matrix visual with Project and then Team Member to give you what you're looking for.