Forum Discussion

macgeorge's avatar
macgeorge
Helper I
3 years ago
Solved

Calculating Percentages

Hi, I am trying to use a measure to produce % of Total column that shows the percentages of Compliant against Priority. I have goine wrong with the code below as it is not showing as a % of 100 - i.e...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi macgeorge ,

     

    Please try:

    % of Total = 
DIVIDE (
    SUMX ( VALUES ( 'Table'[Priority] ), SUM('Table'[Compliant])),
    SUMX ( VALUES ( 'Table'[Priority] ), [All Compliant] )
)

    then select the measure ->  measure tools and change the format to percentage:

    Result:

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

% of Total = DIVIDE( SUMX(VALUES(table[Priority]),[Total Compliant]), [All Compliant], 0)

macgeorge's avatar
macgeorge
Helper I
3 years ago

Hi Daniel, thank you for your reply. I am still getting 0.45% in that column. I am using this code as you suggested:

% of Total = DIVIDE(SUMX(VALUES(table[Priority]),[Total Compliant]),[All Compliant], 0)
 
Am I doing something wrong here?
  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    =ROUND( DIVIDE( SUMX(VALUES(table[Priority]),[Total Compliant]), [All Compliant], 0),2)

    can this work?

    • macgeorge's avatar
      macgeorge
      Helper I
      3 years ago

      The rounding works, thank you - but I am still not getting the % correct it should read 45% not 0.45%

      % of Total = ROUND( DIVIDE(SUMX(VALUES(Table[Priority]),[Total Compliant]),[All Compliant], -0),2)
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi macgeorge ,

         

        Please try:

        % of Total = 
DIVIDE (
    SUMX ( VALUES ( 'Table'[Priority] ), SUM('Table'[Compliant])),
    SUMX ( VALUES ( 'Table'[Priority] ), [All Compliant] )
)

        then select the measure ->  measure tools and change the format to percentage:

        Result:

         

        Best Regards,
        Gao
        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly -- How to provide sample data