Forum Discussion
Tier Formula
Based off of the following data:
How can I create DAX that will give me the appropriate dollar amount that each person is supposed to have based on their tier and satisfaction %? The targets would be:
86% = Satisfaction Bronze
90% = Satisfaction Silver
94% = Satisfaction Gold
So for instance an output would be:
2 Replies
Hi Anonymous,
It seems that you may need to unpivot the columns Satisfaction Bronze, Satisfaction Silver, Satisfaction Gold to be one column first, then create the realtionship of the two tables.
Besides, I 'm a little confused that the logic of your output.
86% = Satisfaction Bronze
90% = Satisfaction Silver
94% = Satisfaction Gold
So for instance an output would be:
The satisfaction % of Timothy Witten is 89.99%, and the output show that Satisfaction Level is Satisfaction Bronze which matched 86%. So could you describe your condition about the level in more details, so that we can help further investigate on it?
Best Regards,
Cherry
v-piga-msft Yes, it's supposed to be a range. So 86%-89.99% would classify a person as having Satisfaction Bronze. Once he hits 90% flat he will then be in the Satisfaction Silver category which would then change the amount of bonus he would earn.
