topic Re: Help with a measure % which is over 100% in DAX Commands and Tips

Help with a measure % which is over 100%

roryv2002 — Fri, 07 Jul 2023 08:17:27 GMT

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%

Re: Help with a measure % which is over 100%

some_bih — Fri, 07 Jul 2023 11:11:58 GMT

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!

Re: Help with a measure % which is over 100%

roryv2002 — Fri, 07 Jul 2023 11:37:26 GMT

Hi it nearly works, it puts it at 10000.00% rather then 100.0%

Re: Help with a measure % which is over 100%

some_bih — Fri, 07 Jul 2023 11:44:41 GMT

Hi roryv2002 then update "100" to "1". Let me know the results.

Re: Help with a measure % which is over 100%

roryv2002 — Fri, 07 Jul 2023 11:52:52 GMT

it still doesnt work, it puts eveytthing to 100% or 200%

Re: Help with a measure % which is over 100%

some_bih — Fri, 07 Jul 2023 12:07:08 GMT

roryv2002 let me know what do you want to be shown as result when

SUM('daily_aggregated_calls_v1'[calls_handled_lt_20sec]) = zero