topic Re: I need help on how to calculate a percentage in DAX Commands and Tips

I need help on how to calculate a percentage

EaglesTony — Fri, 12 May 2023 14:51:24 GMT

Hi,

I have the following:

Team Total Points New Work Points BAU Work Points

ABC 282 237 45

DEF 45 20 25

I need to calculation the percentage of the Total Points for each "New Work Points" and "BAU Work Points".

If would look like:

Team Total Points New Work Points BAU Work Points New Work PCT BAU Work PCT

ABC 282 237 45 84% 16%

DEF 45 20 25 44% 55%

Total Points on the report is "SUM" as is New Work Points and BAU Work Points.

I tried creating a new column with DIVIDE(New Work Points, Total Points) and making that column as "SUM", but for the first Team (ABC), it is giving me 47.00 ?

Re: I need help on how to calculate a percentage

Ajendra — Fri, 12 May 2023 16:01:17 GMT

Hey Dear,

Try this...

Thanks!!

Re: I need help on how to calculate a percentage

EaglesTony — Fri, 12 May 2023 17:16:19 GMT

To get to this, do I create a new column or create a new measure ?..

Re: I need help on how to calculate a percentage

Ajendra — Fri, 12 May 2023 17:50:06 GMT

I achived this through "Measure"..you can do it through "Measure" as well!!

Please consider as a solution to my reply and mark as solution. Thanks!!

Re: I need help on how to calculate a percentage

Ajendra — Fri, 12 May 2023 17:51:26 GMT

BAU PCT =

var _TP = MAX([Total Points])

vAR _BAU = MAX(FactTable[BAU Work Points])

VAR _Result = _BAU/_TP

return

_Result

New Work PCT =

var _TP = MAX([Total Points])

vAR _WP = MAX([New Work Points])

VAR _Result = _WP/_TP

return

_Result

Re: I need help on how to calculate a percentage

EaglesTony — Fri, 12 May 2023 17:54:34 GMT

That didn't work, for some reason for the first row it calculated 1.00

Re: I need help on how to calculate a percentage

Ajendra — Fri, 12 May 2023 18:02:50 GMT

Change format from the BI-Ribbon of your measure. (Keep that in Percentage)

Re: I need help on how to calculate a percentage

EaglesTony — Fri, 12 May 2023 18:08:30 GMT

Still no luck..I chnaged the format to Percentage and showing 100%

Re: I need help on how to calculate a percentage

Ajendra — Fri, 12 May 2023 18:14:07 GMT

Okey!!

share me you file on ajen.indra@gmail.com

let me do this!

Re: I need help on how to calculate a percentage

EaglesTony — Fri, 12 May 2023 18:49:24 GMT

Cant share it due to company policy.

Re: I need help on how to calculate a percentage

EaglesTony — Tue, 16 May 2023 19:08:52 GMT

I was able to fix it. The issue was I was using a column and not a measure.