Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, i have created a mesure which is doing the following
% Handled - Abandoned <20s =
(SUM('daily_aggregated_calls_v1'[call_handled])/((SUM('daily_aggregated_calls_v1'[call_offered])) - SUM('daily_aggregated_calls_v1'[calls_handled_lt_20sec])/100))
the measure works fine but if i have zero calls in [calls_handled_lt_20sec] then the % is over 100% when a manual calcurlation puts it at 100%
example
Calls Handled 1 / calls offered 1 - calls_handled_lt_20sec 1 / 100 = 100% but power BI is showing it as 101%
it still doesnt work, it puts eveytthing to 100% or 200%
@roryv2002 let me know what do you want to be shown as result when
SUM('daily_aggregated_calls_v1'[calls_handled_lt_20sec]) = zero
Proud to be a Super User!
Hi it nearly works, it puts it at 10000.00% rather then 100.0%
Hi @roryv2002 then update "100" to "1". Let me know the results.
Proud to be a Super User!
Hi @roryv2002 try with if:
IF(
SUM('daily_aggregated_calls_v1'[call_offered]) - SUM('daily_aggregated_calls_v1'[calls_handled_lt_20sec]) = 0,
100,
(SUM('daily_aggregated_calls_v1'[call_handled]) / (SUM('daily_aggregated_calls_v1'[call_offered]) - SUM('daily_aggregated_calls_v1'[calls_handled_lt_20sec])) / 100)
)
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
17 | |
10 | |
10 | |
8 | |
6 |
User | Count |
---|---|
18 | |
16 | |
15 | |
12 | |
10 |