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 

 

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.