Forum Discussion
Joined Data Repeats SUM for Each Line
Hello, As this is my first post, please pardon me if it's not quite the standard, but I promise to adapt and catch up quick. I performed a search on other forums within the Power BI message board...
When looking at your Relationsihips, under 'Managed Relationships', make sure everything is set to BOTH under the Cross Filter option. For smaller data sets this just makes joining easier.
Forrest
Hi Forest,
Thanks for the heads up. I verified the that the Cross Filter was set as "Both". Interesting enough, I am able to reproduce the multiplier effect using just a few sample rows/columns as provided in the problem statement (*as my original tables have many more).
Thank you,
Byron D
Thanks for the heads up. I verified the that the Cross Filter was set as "Both". Interesting enough, I am able to reproduce the multiplier effect using just a few sample rows/columns as provided in the problem statement (*as my original tables have many more).
Thank you,
Byron D