Forum Discussion
Helper IVirtual/Temp Tables and Relationships
Super UserHi sbuster ,
This depends on what you refer has a new table, saying this because the title refers to virtual/temp tables but the text seems to be talking about a table added to your model.
If you create a new table on the model the relationships are not inherit, and you need to create the ones that are needed.
However if you refer to a variable created within a measure logic for example those will have impact by the models.
Helper IMiguel, the title is confusing but you further provided clarity... if I interpret what you are say:
1) When I create a virtual/temp table within a measure then relationships are maintained / used in row/filter context where appropriate.
2) If I author a new table which is the result of a DAX statement (i.e. not an external source) then no relationships are maintained. I would have to add relationships manually
Is this accurate?
- MFelix
Hi sbuster
Correct, the only way a filter context be forced to be used or not is having the use of an ALL statement or a summarize that refers to those related tables, however this is only to get the data, after the calculation is done the result is independent of the relationships in the table.