How to prevent double-counting data

[bethcurnutt]

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])/(DISTINCTCOUNT([TMAP_TRP_END_DT]))

The issue that I'm running into is that I think the TMAP_TRP_END_DT is being double counted, causing the numbers to be small than what they are. What can I do to prevent this?

Thank you!

[v-juanli-msft]

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

[bethcurnutt]

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!

[Anonymous]

Can you post some sample data and expected output, that will help to understand the root cause.

Thanks

Raj