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. the first percentage should read 45.4374% (ideally want this rounded up to the nearest percent like 45% as long as the whole table adds up to 100%)
 
% of Total = DIVIDE( [Total Compliant], [All Compliant], 0)
 
PriorityCompliantAll Compliant% of Total
Product 196621260.454374
Product 2321260.001411
Product 33221260.015052
Product 4121260.00047
Product 52321260.010818
Product 661921260.291157
Product 740421260.190028
Product 81621260.007526
Product 96221260.029163
Total2126  

 

Can anyone please help me with this? I am still new to Power BI and figuring things out. 

 

Thank you,

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

6 Replies

  • 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?