Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Restructuring or adding measures to transform existing data into a matrix style table

I have a table of people from multiple offices and projects: Table1: Project# employeeID Office Gender X008 001 A M x008 002 A F x009 001 A M x010 003 B F x008 004...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    You cannot use the matrix visual to create other visuals. But you can create a calculated table based on Table1 to get the same result as your matrix visual. Then you can use this calculated table to create other visuals.

    MatrixTable = SUMMARIZE(Table1,Table1[employeeID],Table1[Office],Table1[Gender],"ProjectCount",COUNT(Table1[Project#]))

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , bit confused table 2, should be possible with count(Table[employeeID]) or count(Table[Project #]) as measures or when you add the column to visual choose count as aggregation

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I just tried again adding the count of table2[employeeID] with table1[gender] and the pie chart is producing a 50/50 distribution of gender - which i assume it is getting due to the fact that there or 2 choices in the gender column.