Forum Discussion

PedroAzevedo's avatar
PedroAzevedo
New Member
10 months ago
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: ...
  • parry2k's avatar
    10 months ago

    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 )
    )