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 i...
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.

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.