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

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.