Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
How about AllEXPECT function? I need to exclude the AM B & C from the Average.
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
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |