I need your support.
I have a calculation which shows me the plan fulfilment per employee to a target value. I also have a support table which shows a bonus value per target value. With the following formula the value per employee is not shown. does anyone have an idea?
For Example the correct bonus value for a seller with a performance of 1.39 is 0.013
Sales People Bonus Rate = var RankingDimension = Values('Staff Total Sales'[Pers.-Nr.]) Return CALCULATE(SUM('Sales People Bonus'[bonus]); FILTER(RankingDimension; COUNTROWS( FILTER('Sales People Bonus'; [Sales People Performance %]='Sales People Bonus'[% Performance to Salesbudget]))>0))
My supporting table looks like
This is my data model