How can my table connection be?

[Gustavo91Peru]

Hi guys, im having some troubles with the connections of my tables.

Initially I had 2 tables:

Interactions and clients, they obviously are connect by the ID number. They have the following component.

Interaction_Table: CREATION DATE ; INTERACION TYPE (It should be client creation in order to be considered);CLIENT ID (It can be a blank value); ORIGIN 

Cient_Table : CREATION DATE; CLIENT ID; ORIGIN; LEVEL OF INTEREST

I want to have 02 graphics.

First one will show how many new clients do I have according to its origin.

Second one will show how many clients do I have according to its level of interest.

I need to have 02 filters: Year and Origin, so my graphics could be interactive.

So far I´ve created and calendar table, but origin filter doesnt work for the second graphic.

What can I do? 

Thanks!!!

[v-frfei-msft]

Hi @Gustavo91Peru ,

Please set the relationship to both instead of single to work on it.

[amitchandak · Accepted solution]

@Gustavo91Peru 

Have an inactive date join between date and client. And Active between client and interactions.  Date and Interaction - Active.

For a measure you need the Client and date join and use userelation.  If need add a cross join for Either Date and Interaction  or client -Interaction 

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...