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: ...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    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 )
)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 months ago

PedroAzevedo In this case, I would recommend providing a little more example data to produce what you have shown. Maybe I missed something, the sample data was very limited hard to understand why it is not working.

 

  • PedroAzevedo's avatar
    PedroAzevedo
    New Member
    10 months ago

    I created a blank PBIX file and added some sample data to test your solution, and it works perfectly. The issue was caused by the relationship between the Calendar Date table and the Date field in the Action table being set to both directions, but the relationship line was hidden behind another table card in the Data Model (thanks to Power BI’s UI/UX).

     

    Thank you so much for your patience and help!