Forum Discussion
tschoeny12
4 years agoNew Member
Matrix Table Summing rows across columns
I have two tables of data that i'd like to merge into a single table. Why is it summing the row data for 'Done'.
Jeanxyz
4 years agoPower Participant
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.
tschoeny12
4 years agoNew Member
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...