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.

amitchandak's avatar
amitchandak
Super User
6 years ago

robandemmy , seem like you using if in some calculation if so use the filter

 

Or try to have calculation like this

sumx(summarize(Table, Table[project Number],Table[project line],"_1",[measure]),[_1])

//Group by which I add are the rows in you matrix, can not see the all name