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.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        5 years ago

        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

        Community Support Team _ Janey
        If this post helps, please consider accept as solution to help other members find it more quickly.