Setting a limit on measure

[gauravg3]

Looking for assistance here:

I've a measure (in %) whose value exceeds more than 100%.

Is there a way that I can set a limit on this measure that if the value is more than 100%, it should show it as 100% and not the actual value.

Example : if the output is 145%, I would want to show it as 100%.

One of the ways is using an IF function

(

IF([Measure A]>1, "100%", [Measure A]

)

but this way the output is in text format, which I don't want as then I can't use it for any further calculations being in text format.

Thanks for your support.

[Ashish_Mathur · Accepted solution]

Hi,

Remove the double quotes from your measure and replace 100 with 1.  Format the measure as %.

Hope this helps.

[v-tianyich-msft · Accepted solution]

Hi @gauravg3 ,

You can also use value() for subsequent calculations.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

Remove the double quotes from your measure and replace 100 with 1.  Format the measure as %.

Hope this helps.