I need help on how to calculate a percentage

[EaglesTony]

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 ?

[EaglesTony]

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

[Ajendra]

Okey!! 

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

let me do this!

[EaglesTony]

Cant share it due to company policy.

[EaglesTony · Accepted solution]

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

[Ajendra]

Hey Dear,

Try this...

Thanks!!

[EaglesTony]

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

[Ajendra]

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

[EaglesTony]

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

[Ajendra]

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

[Ajendra]

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!!