Forum Discussion

Kaskazi_Network's avatar
Kaskazi_Network
Helper I
6 years ago

DAX formula

Hi,

Im working on some data where various sales reps are attached to a stocking point. Each sales rep has a daily target of 35 visits and to do this I used the formula;

Daily Targets = 35 * DISTINCTCOUNT( ('eazeretail v_all_calls'[date])).
But now some stocking points have more than one sales rep so that means a stocking point with let's say 3 sales reps should have a cumulative daily targets of each sales rep which should be 105.
How do I achieve this?
Thankyou.
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Kaskazi_Network ,

     

    Can you share some sample data please and then explain your query?

    I am not 100% clear on what you are looking for.

     

    Thanks,

    Pragati

    • Kaskazi_Network's avatar
      Kaskazi_Network
      Helper I
      6 years ago

      Pragati11 Each stocking point (wholesaler) is allocated a sales rep who has a daily target of 35 visits as shown on the right hand visual. However some stocking points have more than one sales rep hence the targets need to adjust depending on the number of sales rep. For example, 'SAM WEST DISTRIBUTORS' has 3 sales rep attached hence the daily targets need to be 105 (35*3).

      So now I need a formula whereby the targets adjust depending on the number of sales rep attached to a specific stocking point.

      I hope I'm clear now, Thanks

       

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        5 years ago

        Hi , Kaskazi_Network 

        Sorry.It’s  not very clear.

        In the screenshot you provided, I did not find the 3 sales rep of 'SAM WEST DISTRIBUTORS' you mentioned.

        If possible , can you share relevant sample data?

         

        Best Regards,
        Community Support Team _ Eason