help needed on data relationship

[Anonymous]

Hi Everyone,

I am facing a challange in the below 

Employee table - Deparment table - Sugggestions table . below are the relationships 

 i am trying to get the dpearment details from the department table and employee details from the employee table plus the number of suggestiosn for each emploee as per the below dax 

but i get the employee repeated 37 times which are the number of the departments in the department tables .

Weekly Suggestions = Calculate([Total Number of Suggestions], DATESINPERIOD(Calendar[Date], MAX('Calendar'[Date]), -7, day))

would appreciate any guidance or help

thanks 

[v-xiaotang]

Hi @Anonymous 

usually information below is needed, could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result based on the sample you provide. If calculation formula is involved, please provide it.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

can you share a sample PBIX file ?