Forum Discussion
How to prevent double-counting data
Hello, I'm currently trying tog et some data for driver metrics. I have the following function set up: Stops/Driver/Day = COUNTA(TMAP[TRP_STOP_ID])/DISTINCTCOUNT(TMAP[TMAP_PRIM_DVR_ID])/(DIST...
Hi bethcurnutt
As tested, I can't find TMAP_TRP_END_DT is double counted, what is your situation?
Column 4 = (DISTINCTCOUNT([TMAP_TRP_END_DT]))
Best Regards
Maggie