Forum Discussion
Making different relationships active
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
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]))
1 Reply
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]))