Sync two date slicers from different tables

[Anonymous]

Hi Team,

I have 3 tables in my model as below named Leads, leadids and Deposits

and the relationship is as below

Email (Leads) {1} ----------> {Many} Email (Lead ids)

Service UID (Lead ids) {Many} <---------> {Many} EID (Deposits)

I want to create a page where I would keep Sys Creation Date (Leads), Aff id (Leads)  as a slicer
A Table with Aff id (Leads),  Status (Leads)
A Table with Aff id (Leads), Deposits (Deposits)

There are two page level filters
Service UID (Lead ids) not blank
M Campaign ID (Deposits) not (-1)

Now when I select September 2019 in the Sys creation Date (leads) Slicer I see 49 Deposits
but when I select the same in Date (Deposits) Slicer I see 204 Deposits which is entirely correct as these are two different date columns

So I want to sync this two filters so that when I select let’s say September 2019 in Sys creation date slicer I want the Date slicer to be automatically filtered to September 2019 and give me the deposits value for the Date Slicer not Sys creation date slicer
I don’t want to keep Date slicer in the page too which will make user to select same value in both the slicer

Solution Tried:
1. I tried to Create a calendar table and tried to connect both Calendar (leads) and Date (deposits) with an active relation but it gave me following error

2. I tried to create a measure with following

Deposits2 = CALCULATE ([Total Deposits], USERELATIONSHIP(Calendar__leads[Date],Deposits[DATE]))

But it gave me total deposits as 49 for selecting September 2019 in the Sys creation Date (leads) Slicer whereas I expected 204

3. I tried to create another measure as
Deposits3 = CALCULATE ([Total Deposits], TREATAS(VALUES(Leads[SYS_CREATATION_DATE]),Deposits[DATE]))

but it gave me some unexpected no as 40

I am just trying to understand if this can be possible with DAX

Thanks

[amitchandak · Accepted solution]

@Anonymous , Many to Many between Deposits and Leadids is causing that.

Try to create one more common dimension to analyze and remove Many to Many join

refer

https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified