Increasing/Changing Target and Max on Gauge

Question

Hi All,&nbsp;My data is coming from a direct query. I am trying to set a daily quota of 75 transactions for each employee and use this as the Target value in the gauge. I am currently hard-coding these numbers but would like them to change as I select multiple dates.When I select multiple days I want the Target to total 75 for each day selected (would be 150 in the below screen shot). Also, I would like the Max to be 60% higher than the Target.Each transaction is a line in my data and the daily transactions by employee are a count on the columns.&nbsp;Any DAX suggestions to solve this?&nbsp;&nbsp;

greg_deckler · Answer

Anonymous&nbsp;- AVERAGE or AVERAGEX? Hard to tell without seeing some sample data.&nbsp;Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

anonymous · Answer

Hi Anonymous,
I think you can write measure formulas to interact with slicer selection and display the dynamic target and max value based on selected ranges.
If you confused about coding formulas, please share some dummy data with the expected result then we can test and coding formula on them.Regards,
Xiaoxin Sheng

anonymous · Answer

This is what the chart currently looks like:

This is how I would like it to look:

Here is a sample data set (I hit the 20,000 character limit with 2 employees):

Employee	Date	Status	Count if Completed
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/1/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1
Employee 1	9/2/2020	Completed	1

Forum Discussion

Increasing/Changing Target and Max on Gauge

3 Replies

Related content

Gauge visual with multiple targets

Gauge: dynamic target value

Gauge losing target value upon filtering

Gauge with dynamic target

Gauge Visual