Help with formula for scatter chart

[jakeryan56]

Hi team!

So I have created this visual using the scatter chart visual. Both axes are based off a score between 0 and 100.

I have created green, white and red zones to indicate different levels of performance.

How would I extract the performance level (green, white, red) through DAX formulas? I need this so I can create other calculations based on this but I have tried using If(and( functions and then got really lost because of the complexity of working in an extra dimension.

Any ideas?

[v-yuta-msft]

@jakeryan56 ,

Your requirement is not so clear. Could you share more details about the "performance level" you mentioned? If possible, please share some dummy data and show the expected result.

Regards,

Jimmy Tao