Forum Discussion

bethcurnutt's avatar
bethcurnutt
New Member
8 years ago

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])/(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!

3 Replies

  • bethcurnutt's avatar
    bethcurnutt
    New Member
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

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

       

      Thanks

      Raj

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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