Forum Discussion
Solved
Matrix Summing Totals
Hello, I am having trouble getting a visualization to work properly. I have two tables (approved and spent) that each have "project number" rows and "task" columns. Can use the matrix visual fine...
robandemmy OK so now you have a many-to-many which tends to be a bad thing. Generally, to fix this and make it work correctly, you need to create a bridge table like:Table = DISTINCT('PCSData'[Task])
You relate this to both of your tables and use the Task column in this bridge table in your visualizations.
Generally when you see things like that their is a bad or missing relationship between 2 tables.