Forum Discussion
sbuster
Helper I
Helper IVirtual/Temp Tables and Relationships
When I create a new table based on a DAX formula, is there some type of 'inherit' relationship between the new and old tables? For example, if I have a details table with many keys, then create a ro...
sbusterHelper I
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
Super User
Super UserHi 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.