Table relationships

[timazarj]

Hi,

in my model I have a Date table, using it a slicer, Employee table, using it for usercode. there are 2 different tables for Sales and Returns. I created the relationship between the Date to Sales & Returns to filter the monthly sales and returns. Also created a relationship and connect Employee to Sales & Return to show the employees' name rather than the codes and also be able to filte the names in the report. the relationships are 1-* and single. Now that I run the report it works well for the returns but not for the sales, the numbers are blank. Please advise me.

[SivaMani]

@timazarj,

Is it possible to share your model diagram? Your result screenshot?

[timazarj]

The right side should show the sales diagram and numbers which are blank now.

[PaulDBrown]

@SivaMani 

You should set up the Employee table to have a one-to-many relationships with both fact tables instead of many-to-many.

Also, can you post the measures you are using in the visuals?

[timazarj]

I did change that still not working

[timazarj]

Upsells = CALCULATE(COUNT('Sales'[ActivityCode]), FILTER('Sales','XDAT-Upsell'[ActivityCode]= "UPSE"))

[SivaMani]

@timazarj,

Is it possible to share the pbix file (without any sensitive info)?

[timazarj]

 Yes, can I have your email address?

[SivaMani]

@timazarj,

X-DAT and Upsells are calculated measures?

[timazarj]

yes they are.

[SivaMani · Accepted solution]

@timazarj,

Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

[timazarj]

I changed the data type of the Return table in Power Query and it worked.

[timazarj]

I ensured that the Date column, EffectiveDate, and EnteredDateTime in the three tables have the same data type and format, and there are matching records for Date. Still no result.