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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

robandemmy not sure how the relationship is set up between these tables, the recommendation would be to have separate project and task table and have a relationship with both these tables and then use these new dimension tables in the matrix visuals.