Calculate Dynamic Rolloing Total Based on Slicer

Hi,

Based on what you have written, I have not understood the reason behind creating the "Country" slicer based on "Training" table. Because "AllStaff" is likely to have unique values. But in Training table, If one staff had opted for multiple training, exams etc..., this table will likely to have multiple entries per staff.

Therefore, assuming that you have created the relationships correctly between these two tables and if there are 125 Staffs from Germany and out of which 36 of them had participated in any training or exams, but some of the staffs have taken more than one training / exam because of which the Training table shows 46 entries. In this scenario, choosing the "Germany" will not give 36 as a the result because it is the number of unique Staffs in Training table for which master is available in the "AllStaff" table.

If you want 46 as the result, then you must link the card to Training table so that it will count the duplicate entries also. If you want number of unique users from Germany who wave participated in training or exam, then you have to link the card to "AllStaff" table. 

The choice is up to you. I don't see any other reason for the unintended output.