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

=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

    • macgeorge's avatar
      macgeorge
      Helper I
      3 years ago

      Thank you so much - this is excellent.