Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
roryv2002
Frequent Visitor

Help with a measure % which is over 100%

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% 

5 REPLIES 5
roryv2002
Frequent Visitor

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






roryv2002
Frequent Visitor

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






some_bih
Super User
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!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.