Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with my DAX formula

Hello! So in the screenshot shown below I have two visuals. The left one is made using custom measures (which I will include) and the right one is just using Power BI. Some cells on the right visual...
Need Help
  • kentyler's avatar
    kentyler
    6 years ago

    Is there a reason you have a bi-drectional relationship between the tables ? This seems to be the kind of problem bidirectional relationships can cause.

kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

Is there a reason you have a bi-drectional relationship between the tables ? This seems to be the kind of problem bidirectional relationships can cause.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    kentyler And you were right! I dont remember why I set it to bidirectional but yes that was a mistake. But why though, could you please explain to me a bit what the bidirectional selection did to cause that?

    • kentyler's avatar
      kentyler
      Icon for Solution Sage rankSolution Sage
      6 years ago

      Sorry

      I am not fluent enough to explain exactly why. I just know it as a best practice. The Italians says "Using bi-directional relationships can lead to strange outcomes on reports, so don't use them unless you absolutely have to"..... so I try to follow the best practice...even though I might not understand the "complications"  https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/