Active relationships using DAX


#1

Hi,

No need to answer question. Found the Active vs inactive relationships

It is my understanding there can only be one active relationship between two tables.

Does using DAX, to make an inactive relationship active, create a situation where two active relationship exist so a measure will not have the correct output value.

In this scenario, there is active relationship in the model and again when I use DAX another active relationship.

Thanks in advance.
Elizabeth


#2

There could be only one active relationship between tables at all times and a number of other inactive relationships as well.
These inactive relationships come alive using the function USERELATIONSHIP(), most often used in conjunction with CALCULATE().

But, to answer your question (even if you don’t want it answered), DAX doesn’t create or use two active relationships, rather activates an inactive one and performs calculations accordingly.


#3

Dear Dimbroane,

Thank you!