Matrix Table Summing rows across columns

[tschoeny12]

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]

@tschoeny12 , I was quite sure it's due to a relationship issue, now I'm perplexed. Did you create a calculation group under Name?

Please upload a sampe pbix file if possible. 

[davehus]

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.

[tschoeny12]

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?

[Jeanxyz]

@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]

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...