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...
Hello,
I'm trying to get certain data metrics from driver performance. This is the formula I'm using:
Stops/Driver/Day = COUNTA(TMAP[TRP_STOP_ID])/DISTINCTCOUNT(TMAP[TMAP_PRIM_DVR_ID])/(DISTINCTCOUNT([TMAP_TRP_END_DT]))
The TMAP_TRP_END_DT is in a date format. The issue I'm running into is that the numbers are coming out lower than what I know they should be, so I believe this date is getting double-counted. How do I prevent this?
Thank you!
Can you post some sample data and expected output, that will help to understand the root cause.
Thanks
Raj