Forum Discussion
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...
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.
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
Additionally a bar chart of
Axis: table1[gender]
Legend: table1[]gender]
Value: Count of table2[index]
gives me two columns male and female, each with count 4