Solved: Error Combining Data Of Two Tables

Yrstruly2021 · ‎03-30-2021

I am trying to replicate these two "pivot" tables here: https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing so that i can do calculations between the two.

Currently my data model does not allow to filter between these two tables. It gives an error when i select columns from both sets. What am i doing wrong?

PBIX:

https://drive.google.com/file/d/186vsjbqclSXB4m5LGwdp3agMQ6-63LDs/view?usp=sharing

vanessafvg · ‎03-30-2021

hi yours truly from south africa by any chance, i remember all these products 🙂

the problem was your calculated fields cat and one that i removed was creating a circular dependency. I remove and recreated them and set the relationship to active so you can link them see attached

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

View solution in original post

vanessafvg · ‎03-30-2021

use the matrix object rather than the table and place the months on the columns

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

vanessafvg · ‎03-30-2021

hi yours truly from south africa by any chance, i remember all these products 🙂

the problem was your calculated fields cat and one that i removed was creating a circular dependency. I remove and recreated them and set the relationship to active so you can link them see attached

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!