I am trying to count the number of employees(distinct, as they tend to come back or go to another branch and still appear in the table under another branch) at a certain branch over different periods of time. I am attaching a sample below. I am trying to get the number of employees that are working at Branch “Doe”. My report will also be containing the year and quarter filter. And, I was wondering if somebody could help me figure out why my results are cumulative irrespective of the filter option applied to the quarter. This is probably pretty simple, I am a newbie when it comes to DAX and so any help would be appreciated.
Test_numbersenrolled.pbix (58.5 KB)