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 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 )
)
For some reason this is the output for my actual dataset when I selet 2 CONSULTOR from Accoun table, it only shows 6 as the goal for the days where both CONSULTOR had an ACTION.
