join in data model

Hi All,

i want to join date dim with multiple facts

table with col

date table = ddmmyyyhhmm

sales facts = ddmmyyyhhmm

Target facts=ddmmyyyhhmm

joins

date table1:M sales facts (both) - is working

now i need to join date table to target table  if i do same join as i did with sales facts its not working

In the pic DAY is from date dim , if i select DAY 28 , my sales facts is filters on 28/1/2020 with time stamp, but the other timestamp from target table is no record is visible.

In my report i need to show  sum(sales) as line and from target table avg(target amt ) as bar chart by DAY WISE