Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
9 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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]))

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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]))