Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Conditional Measures with two conditions

Hi experts,

 

I'm trying to write the formula to calculate the bonus points as the conditions below:

 

RankBonus Points based on achievement
 Achieved 100% - <120%Achieved over 120%
Silver0.60%0.60%
Gold0.60%0.80%
Diamond0.60%0.80%

 

Each store will have different ranks (silver, gold, diamond) and based on their achievement rate (sales/target), they will got bonus points. 

 

I can't create a calculated column due to RLS so I tried to write a measure but it took so long to process. 

 

Any helps would be really appreciated.

 

Thank you so much!

 

Need Help

1 Reply

  • HiraNegi's avatar
    HiraNegi
    Icon for Resolver II rankResolver II
    3 years ago

    Hi,

     

    Have you already got the achievement rate calculated ? If so, then you need to compare the achievement rate with the Rank.

    Provide some sample data to understand the issue. Thanks.