Forum Discussion
Solved
Having trouble creating dynamic goal
Hello! I'm having trouble with this specific issue, and it's not the first time I give up on having dynamic goals, because I can't get it to work, ever. The current situation is as follows: ...
PedroAzevedo here is what the measures looks like:
Goal = VAR __CountConusltor = DISTINCTCOUNT ( Accoun[CONSULTOR] ) RETURN __CountConusltor * 3 Action = CALCULATE ( DISTINCTCOUNT ( Accoun[PARTNR] ), CROSSFILTER ( 'Action'[ACCOUN], Accoun[ACCOUN], BOTH ) )
parry2k
Super User
Super UserPedroAzevedo when you have selected MARK why action count is 0 on 2025-01-05
It was a typo, AC5 belongs to MARK too, so it should be 1, I edited the previous message.
And yes, I'm trying to get the daily goal, but it should be the same goal for every day (except for weekends but I can add a IF in the end of the measure to deal with that).
