Two Data Tables into one matrix

[Jpahl2033]

Hi,

I am trying to put two tables into one matrix. The first table works fine, but when i bring in the second data table, as a value, it only displays the total instead of by row during the data. I have these two tables connected by a one to many relationship from a data table. 

Thanks

[v-easonf-msft]

Hi, @Jpahl2033 

Can you show the fields involved in your matrix? In addition, it is recommended that you use a separate date dimension table.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Make sure you have created a relation with correct columns, relation with wrong columns may leads to inappropriate data.