Add a high value limit to a measure

[bn12pmebi]

I have a measure adding together 6 values to create a total.  It's possible for the sum to be greater than 100, but in these situations I want PowerBi to just show 100 instead of 102, for example.   How do I add this kind of limit?

[bn12pmebi]

Thanks, that did it!

[Syk]

In your measure we can add an if statement to handle this! It would look something like...

Measure = 
var addvalues = sum(table[value1],table[value2])

return if(addvalues>100,100,addvalues)

 This basically checks to see if your measure would return something greater than 100, if so, just return 100. If not, return the original value!

[bn12pmebi]

It's a very simple measure adding together other measures, like [1]+[2]+[3].  how would I apply your solution in this example?

[Syk · Accepted solution]

Basically taking your measure and just having it be the variable

Measure = 
var addvalues = [1]+[2]+[3]

return if(addvalues>100,100,addvalues)