Dynamic gauge targets

[Anonymous]

Hi all - I'm working on a revenue gauge visualization, and I've hit a wall. I want the revenue target/goal to show up based on that individuals name being selected in the slicer.

What measure/DAX should I be using to return this value by the person's name?

Year	Manager	Goal
2022	Steve	$        5,000,000
2022	Nancy	$      60,000,000
2022	Bobby	$        1,500,000
2022	Ricardo	$        7,000,000

[amitchandak · Accepted solution]

@Anonymous , if you simply create a measure

sum(table[Goal])

And filter manager column(using slicer) for this table that will change

[Anonymous]

Thanks - I had to move my slicer 1 level up on my schema and it worked! 

Really appreciate the help.