join in data model

[Anonymous]

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

[Tahreem24 · Accepted solution]

@Anonymous ,

Which type of Cardinality you are using for all three tables? 

I checked at my end and got correct result.

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Interesting, I am also using same cardinality .

but there are other table as well in the data model , does it affecting this relationship

[v-gizhi-msft]

Hi,

Could you please share your all relationships among tables as a screenshot?

Best Regards,

Giotto Zhi

[Anonymous]