Forum Discussion
Dates table relationship not working properly
Nevermind. I finally figured it out. There was a 'Margin' measure inserted into the table
= 1 - SUM([Cost]) / SUM([Sales])
which messed it all up. Such a stupid mistake.
Thank you anyway.
Hi Tomfiki
I've had a look at your file... Why do you use bi-dir filtering on dates? I can't see a reason why this should be so. What's more - IT SHOULD NOT BE SO. Please stay away from bi-dir filtering as much as possible if you want to stay sane and want to understand what your model produces (look for one of the latest vids from Alberto Ferrari on YT about why you sholud not use bi-dir filtering). There are very precise rules WHEN bi-dir filtering should be used; your model does not guarantee them. That's the first observation. The second is this: such reports should be created as paginated reports, not as regular PBI reports. PBI is meant to summarize data and it's really good at it, not to display details the way you're trying to do. To do what you want you should revert to the Report Builder for paginated reports.
Hi daxer-almighty,
Thank you for your advise.
I've now watched the YT video you mentioned and removed the bi-dir relationship from dates tables.
Can I ask what are the exact rules? I understand I should never use bi-dir relationship when it creates 2 (or more) pathways from one table to another. But if it is only between 2 tables while one of them has no relationship with any other table... why it then creates an issue?
Regarding your second observation - I just need this one page to list all the details available. Apart from that I have multiple other pages to summarize and display data while dynamically selecting measures etc. - to the best of my very limited knowledge. I just deleted these pages since it had nothing to do with this perticular issue.