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 You explained it very well, kudos to you. Now, can you provide some example output based on what you explained. It will help immensely to provide an effective solution.
Sure, should've provided it from the start!
Without any filters/slices applied, this should be the output (3 unique CONSULTOR times 3 = 9 for all days, actual is the distinct count of PARTNR for the ACCOUN that had one ACTION)DATE GOAL ACTUAL 2025-01-01 9 1 2025-01-02 9 0 2025-01-03 9 2 2025-01-04 9 0 2025-01-05 9 1 If we are filtering for SUPERVISOR 'MARK':
DATE GOAL ACTUAL 2025-01-01 6 1 2025-01-02 6 0 2025-01-03 6 2 2025-01-04 6 0 2025-01-05 6 1
