Filter Value from a supporting table

[Mario-B]

Hi everyone,

i need help for the following case. I have a measure that calculates the performance of the sales people. And a separate table where bonus values are stored for each performance measure.

I need a solution that compares the performance value in the support table and returns the corresponding bonus value.

In my example, the salesperson has a performance of 1.39 and the bonus value 0.013 must be returned from the comparison table. The next salesperson has a performance value of 1.18 and the value 1.18 must be returned, and so on for each sales person.

My support table has noch relationship to my fact table. My Datamodel looks like

[amitchandak · Accepted solution]

Between two table, I assumed name . Table on left in data screenshot is the salesperson

Bouns rate = maxx(filter(Rate,Rate[%performance] =salesperson [%performance]),rate[bonus])

You can add more conditions

Appreciate your Kudos.

[Greg_Deckler]

Tough to say. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, sounds like you need LOOKUPVALUE?