Forum Discussion
Daily Sales Target Calculation
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.
ryan_mayu ,
The output of "Daily Sales Target" is correct, if YEAR and MONTH Filter are selected.
However, If DAY filter selected along with YEAR and MONTH filter. The output "Daily Sales Target" is showing incorrect result. This is due to "Workday" measure filter is affected by Day Filter.
My requirement is to workday measure should not be affected by Day Filter.
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.