Forum Discussion

puru85's avatar
puru85
Helper II
2 years ago
Solved

Daily Sales Target Calculation

Hi Experts, I am trying to calculate the Daily Sales Target.  Logic for Daily Sales Target Calculation:  (50,000 / number of workdays) + 20% Details: I have created a measure to cal...
General Comment
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    puru85 

    I think the solution of workday was provided by another super user. You have some discustion on another thread. I haven't had a chance to go through. 

     

    Here is a workaround that we do not need to touch the DAX part.

     

    turn off the interaction between day filter and daily sales target card.

     

davidding's avatar
davidding
Resolver I
2 years ago

got a feeling that the problem is with the 50,000, is that a monthly target? my interpretation of your problem is that this total target is not changing, but the number of workday changed, so your daily target is also affected.

 

I've split the measures into 3 tables in your file using different period in the table to illustrate the problem. Hope this at least partially answered your question.