% of Job Complete with max 100% calculation

[Anonymous]

I am trying to calculate the percentage of our jobs that are complete but I do not want to display anything over 100%

%_Complete =

SUM('Revenue1'[Total])/SUM('Estimates4'[Amount])

I tried to add a Max and IF statement but got errors.

Thank you for your help!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=if(divide(SUM('Revenue1'[Total]),SUM('Estimates4'[Amount]))>1,1,divide(SUM('Revenue1'[Total]),SUM('Estimates4'[Amount])))

Format this measure as %.

[Jihwan_Kim]

Hi, @Anonymous 

Please try the below measure.

If that is not what you need, if it is OK with you, please share your sample pbix file, then I can try to look into it to come up with a more accurate measure.

%_Complete =

If ( 

SUM('Revenue1'[Total])/SUM('Estimates4'[Amount]) >= 100%, blank(), 

SUM('Revenue1'[Total])/SUM('Estimates4'[Amount]) )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.