Forum Discussion
Utilizing a dynamic measure correctly
Hi Pseifert ,
When you select the one bar in the top visual, you are actually select the date 9/30, then you select the 9/27 in the buttom visual, so there is no data for "count of color team", result the measure 4 is blank divide number, so measure 4 is blank too. Like following example:
Do you want to count for the team which equal to the selected active headcount?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-lid-msft,
Yes, I want to take the active head count number that correlates to the week of the active headcount calculation. For instance, the active headcount value from 9/30 should be used for the days within the prior work week..i.e. 09/27. Is there a way to use that 09/30 value rather than filtering for that day? I do not need to select from both charts, I just need the bottom visual to utilize the correct active headcount value.