Forum Discussion
Dynamic Target in Gauge?
Hi Ojke. From your description, I think you'll need two measures defined as follows (names are up to you):
Average Sold = AVERAGE(TableName[number sold]) Average Sold All Types = CALCULATE([Average Sold], ALL(TableName[type of fruit]))
Then you'll want to use Average Sold as your gauge value, and Average Sold All Types as your target value. The only reason I'm not sure, is the math doesn't add up based on your sample data. I'm hoping you had some additional data included in your calculations but not in your pictured table. Here's what I get:
If all types of fruit are selected and all sellers, the target is 3.86 and the gauge value also 3.86.
If only pears are selected and all sellers, the target remains 3.86 and the gauge value is 6.
If all types of fruit are selected and only John as seller, the target becomes 3.33 and the gauge value also 3.33.
If only pears are selected and only John as seller, the target remains 3.33 and the gauge value is 2.
Hi Ojke. From your description, I think you'll need two measures defined as follows (names are up to you):
Average Sold = AVERAGE(TableName[number sold]) Average Sold All Types = CALCULATE([Average Sold], ALL(TableName[type of fruit]))
Then you'll want to use Average Sold as your gauge value, and Average Sold All Types as your target value. The only reason I'm not sure, is the math doesn't add up based on your sample data. I'm hoping you had some additional data included in your calculations but not in your pictured table. Here's what I get:
If all types of fruit are selected and all sellers, the target is 3.86 and the gauge value also 3.86.
If only pears are selected and all sellers, the target remains 3.86 and the gauge value is 6.
If all types of fruit are selected and only John as seller, the target becomes 3.33 and the gauge value also 3.33.
If only pears are selected and only John as seller, the target remains 3.33 and the gauge value is 2.
Thanks. This solved my problem.
Your numbers add up. :)
