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.
So I did some progess:
Now displays the total of all actual ITD data, not those related to tasks 001 and 002
This is the relationship
You are picking up the ratio 001/002 (task), but not the 407_ (project number)