Relationship error

[subburaj]

Hi Friends - Please find the attached screenshot for your reference. Have 2 table, created relationship using Fiscal Month field. 'Sum of Multi Count' is showing incorrect. Example - for FY2018M01, It should show 4 but it showing 104 in 2nd table. Kindly help.

[subburaj]

Thanks a lot

[v-jiascu-msft · Accepted solution]

Hi @subburaj,

Change "Cross Filter Direction" to "Both". You will get the right result.

Best Regards,
Dale