Distinct Count (Direct Query) - Why is this so hard!?

Hi - me again.  Source data is employee expense submissions in a SQL table via Direct Query.  I want to count the number of expense reports by employee for a given date range (slicer).  I've tried: ...