Forum Discussion

robandemmy's avatar
robandemmy
Frequent Visitor
6 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago


    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.

robandemmy's avatar
robandemmy
Frequent Visitor
6 years ago

So I madesome progess:

 

Now shows total for all ITD Actuals, not the ones related to the 001 and 002 tasksThis is the relationship

It's picking up the 001/002 (task) relation but not the 407_ (project number)

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago


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.