Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
77 | |
60 | |
58 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |