Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

help needed on data relationship

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 

 

 

 

 

Data Protection

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.