Forum Discussion

Tomfiki's avatar
Tomfiki
Frequent Visitor
5 years ago
Solved

Dates table relationship not working properly

Hello all, Could you please help me solve this issue with which I've been losing my mind for hours? I have a 'Data table' with "Invoice date" with a relationship to 'Dates table' which I created th...
Need Help
  • Tomfiki's avatar
    Tomfiki
    5 years ago

    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.

daxer-almighty's avatar
daxer-almighty
Solution Sage
5 years ago

Hi Tomfiki 

 

Bi-dir filters can slow down the model substantially, so it's not only about model ambiguity. Bi-dir filters should be used in a very precise setting: when you have a many-to-many relationship with a bridge table in between the involved tables. But this many-to-many has to be of the sub-type "one-many-many-one," not "many-one-one-many," the latter technically being a granularity issue where you should use the many-to-many relationship (that is, *:*). This is the one legitimate reason to use them.

 

As for the second bit... I told you what is the best way to handle very detailed reports and this method will always be paginated reports since these can gracefully handle the layout down to the very last pixel. Visuals in PBI do not offer this level of customization.