Forum Discussion

JadeDoherty's avatar
JadeDoherty
Regular Visitor
6 years ago

Calculating Percentage of Target with Ramp up

Hello all,   Wondering if someone may be able to assist.  I need to somehow create a measure that can provide me with the desired % of Target readings based on some rules as set out in the example ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

You can use the DAX MIN() function to cap the percentage like so

 

result = MIN(achieved percentage, 1)

 

can never be higher than 100 %

JadeDoherty's avatar
JadeDoherty
Regular Visitor
6 years ago

Thanks lbendlin ,

 

The only issue with that is if the sales person is not on ramp up - the % achieved can be over 100% and we need to show that.