Forum Discussion
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: ...
Im sorry. Instead of primairy key i meant your name column. But im afraid this operation over this column has performance issues
I don't want to countrows of the name column though because one name may have 500 unique expense reports. I want to identify the number of expense reports per person (not number of expense submissions).