Forum Discussion
USERELATIONSHIP Strange behavior !!!
Dear All, I have an issue with the USERELATIONSHIP dax function, I have a blank result when I use it on my measures : First of all this is my schema : Then this is my measures : ...
- When you activate the relationship between the two tables, the model becomes AMBIGUOUS. Please do not do this unless you want to have a hard time troubleshooting and create random numbers nobody will ever understand.
Please stick to this very simple rule of dimensional modeling:
Fact tables can only be joined through dimensions, never directly. The should also have all their columns hidden and measurements should be exposed only via explicit measures.
Try to violate this rule and you'll regret it rather sooner than later.
Best
D
When you activate the relationship between the two tables, the model becomes AMBIGUOUS. Please do not do this unless you want to have a hard time troubleshooting and create random numbers nobody will ever understand.
Please stick to this very simple rule of dimensional modeling:
Fact tables can only be joined through dimensions, never directly. The should also have all their columns hidden and measurements should be exposed only via explicit measures.
Try to violate this rule and you'll regret it rather sooner than later.
Best
D
Please stick to this very simple rule of dimensional modeling:
Fact tables can only be joined through dimensions, never directly. The should also have all their columns hidden and measurements should be exposed only via explicit measures.
Try to violate this rule and you'll regret it rather sooner than later.
Best
D