Forum Discussion
Gage graph
Hello,
The model is like below:
Date/AM/ Calls/Ring no Answer/: for each month:
A/330/2
B/353/1
C/222/0
D/210/4
E/297/0
F/260/2
H/272/0
Measures:
Max Call = Max(Calls(Calls))
Avg Call = Average (Calls(Calls))
There is a gage graph per individual that shows the calls per individual as a value, Max Call as Maximum value, and Avg Calls as a Target Value. but as I change the slicer to AM name's "A" the Max and Average change to 330 and 330. Would you please guide me? I also need to exclude AM "B" & "C"
6 Replies
Hi, timazarj
When choosing A, what are the maximum and average values you want to display? We need the desired result to modify your measure.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For A the gage shows the value 330, Max = Max{330,210,297,260,272}=330, target valu= Average{330,210,297,260,272}=1369/5=273.8~274.
Hi, timazarj
Usually, the value of measure will change according to the context. If you want to fix the average, you can try:
Avg Call = CALCULATE ( AVERAGE ( 'Calls'[Calls] ), ALL ( 'Calls'[AM] ) )Best regards
Janey guo
Community Support Team _ Janey
If this post helps, please consider accept as solution to help other members find it more quickly.
