Forum Discussion
Matrix Table Summing rows across columns
Hi tschoeny12,
It's down to your model relationship. Create a table of newstate as a dimensional table and join it to the two separate tables.
This should resolve the issue.
Did I help you today? Please accept my solution and hit the Kudos button.
I brought in two tables of data from ADO.
1) One for All Stories backlog (to bring out all tasks backlog) and
2) for All Features backlog to bring in the epic information.
I've created the relationships between the tables based on the parent data. When i bring in the 2nd parent ID, it sums the two values instead of keeping them separate. is there something wrong with how i've created the relationships?
tschoeny12 , There is no active relationship between table All Stories and table Feature Names.
Try edit the relationship and make this relationship active. Possibly Power BI stops you from creating an active relationship because there many-to-many relationship between them. If that's the case, you should indicate which table should filter the other table.
Let me try that. Here's another view with the parent work item inserted into rows. I'm not sure why 'Done' aggregates ieach row to 26...
