Forum Discussion

gauravg3's avatar
gauravg3
Icon for Helper I rankHelper I
2 years ago
Solved

Setting a limit on measure

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.

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

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

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

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

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.