Forum Discussion
ssbagley
Helper III
Helper IIIDistinct 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: ...
PVO3
Impactful Individual
Impactful IndividualIm sorry. Instead of primairy key i meant your name column. But im afraid this operation over this column has performance issues
ssbagleyI 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).