Forum Discussion
count function returns distinct count
CALCULATE(COUNT(table[field]),USERELATIONSHIP(table[datefield],calendar[datefield)) why would this return a distinct count ? I tried removing userelationship - same results.
The COUNT function returns the COUNT, not the distinct. If you have used a USERELATIONSHIP it might change the behaviour depending on the context but it should not.
If the COUNT still return a distinct even without the USERELATIONSHIP that means that in the context of where you calculate that formula, the rows are DISTINCT in some way.