Need to join an attribute of a n table

[joaquinel]

Hi,

I need to count contracts from the Fact Table by an Attribute which is three tables away (image below). I don't know how to write correctly the formula. Here you have the simple one. Could you help me? Thanks in advanced.

Main formula: CALCULATE(COUNT(ContratosServicio[Id]),USERELATIONSHIP(ContratosServicio[FechaBaja] , calendario[date] ))

The main formula is mandatory but I want to join ContratosServicio[Id] with MotivosBaja[Codigo]. My mistake is that i dont know how to unify the  fourth table in the formula. i have been using the formula "userelationship" but it isn't allowed to use. 

[ToddChitt · Accepted solution]

This may suffer a bit from the translation engine, but we will try to communicate clearly:

What are you trying to measure here? 

It looks like ContratosServicio is your main dimensin table. It has one to many relationship with the next table, which has one to many relationship to the third table. BUT, then you have a MANY TO ONE relationship to MotivosBaja. 

You use calendario[date]  in your measure, but I don't see it on the drawing.

What are you trying to measure here?

[joaquinel]

It was the "Directions of filters". Thank you.