Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX query question / performance issue

Hey guys, i've just started working with DAX and need some help with a DAX query / performance issue.  I'm using direct query mode and display the data in a matrix.   There are two Tables (one fa...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You do not want to have bidirectional search in a M:M relationship.  You don't even want a M:M relationship between a dimension table and a fact table - this basically says that your dimension table is fake, it is a fact table pretending to be a dimension.  Please rethink your data model.  Ideally a dimension points to a fact in 1:M with single search direction.