Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple Relationships from same table connecting to Date Table

This is likely very intuitive and been answered before but I couldn't seem to find it. I have data that contains a unique ID for the project and lots of milestone completion dates. EX: ID1 has m...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous,

    You can create several relationships between 2 tables however only 1 will be active the rest will be inactive and you have to use USER RELATIONSHIP to make use of them.

    On yor case let's assume you have the link between date and milestone 1 active and with milestone 2 inactive you need to had the following measures

    COUNT OF MILESTONE 1 = COUNT(Table[Column])
    COUNT OF MILESTONE 2 = CALCULATE( COUNT(Table[Column]); USERELATIONSHIP(calendar[date] ; Table[Milestone 2 Date] ))

    The use the date on calendar table on your visuals and the measures on values

    Regards,
    MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you! Some things to add in case anyone else reads this post:

You have to change the semi colons to commas and USERELATIONSHIP has one r.

 

 

COUNT OF MILESTONE 1 = COUNT(Table[Column])
COUNT OF MILESTONE 2 = CALCULATE( COUNT(Table[Column]), USERELATIONSHIP(calendar[date] , Table[Milestone 2 Date] ))

MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Thank you for the correction on the formula my error when posting :)

 

Regading the Comma part for your information that as to do with regional settings and some are with dot comma others with comma.

 

Regards,

MFelix