Making different relationships active

[bhmiller89]

How do I write measures changing active relationships for the same file?

I have a table with "CreatedByUserID" and I have another table with "AcctMgrID," "TechMgrID," and "PMgrID."

I need to write measures and in each measure need to create different active relationships.

In the first measure, "CreatedByUserID" will have a relationship with "AcctMgrID." In the second, "CreatedByUserID" will have a relationship with "TechMgrID" and so on

[Anonymous · Accepted solution]

https://msdn.microsoft.com/en-us/library/hh230952.aspx

Create inactive relationshops between the tables for each of those columns, then the pattern is

Measure for Relationship 1 = CALCULATE( <whatever math you're doing>, USERELATIONSHIP(TableA[ColumnName], TableB[Column1]))

Measure for Relationship 2 = CALCULATE( <whatever math you're doing>, USERELATIONSHIP(TableA[ColumnName], TableB[Column2]))