Gage graph

[timazarj]

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"

[v-janeyg-msft]

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.

[timazarj]

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.

[v-janeyg-msft]

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

[timazarj]

How about AllEXPECT function? I need to exclude the AM B & C from the Average.

[v-janeyg-msft]

@timazarj  Hello, Any updates?

[v-janeyg-msft]

Hi, @timazarj 

You can try it, because logically speaking, it can be displayed correctly without adding all and allselected functions. But there was an error, so I don't know your specific context, so I can only give insurance advice.

Best regards

Janey guo