Tier Formula

[Anonymous]

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:

 

[v-piga-msft]

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

[Anonymous]

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