Forum Discussion

timazarj's avatar
timazarj
Helper II
5 years ago

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...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

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's avatar
    timazarj
    Helper II
    5 years ago

    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's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      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.
      • timazarj's avatar
        timazarj
        Helper II
        5 years ago

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