Forum Discussion
Dynamic gauge targets
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 |
Anonymous , if you simply create a measure
sum(table[Goal])
And filter manager column(using slicer) for this table that will change
2 Replies
Anonymous , if you simply create a measure
sum(table[Goal])
And filter manager column(using slicer) for this table that will change