Grand Total not showing correctly

[Oelshamy]

Hello,
I am developing a Training Report to show different visuals,

One of the visuals is to show the number of Training taken by each department, I have 3 Tables in the Model, 

• Employee Information,
• Training Master, & 
• Emp Training which is a fact table having the Employee ID and Training ID linked with each as a single relationship 
  
  when I add a scorecard for total training showing 213 training,
  
  However, when I convert it to a chart and add a department in the Axis, so I can show the breakdown of each department,  the numbers don't match the total number of training against each Department. 
  
  Can you advise why the breakdown is showing a different number than the total? I have tried to use a measure as a Distinct count but still the same issue. What would be the solution for this? 

Thank you in advance 

[Oelshamy]

Thank you mahoneypat very much ... very useful video 

[v-cgao-msft]

Hi @Oelshamy ,

May I ask if your problem has been solved? 

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[mahoneypat · Accepted solution]

Please see this video for an explanation of how to get your expected totals.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat