Hello, I have built an incentive chart for sales staff.
I have calculated measure showing results for TXCOUNT & BASKET SIZE,
I would like to match these calculated amounts to a predefined table with target values and incentive values
ie: if TX COUNT = 472 that is closest to TX TARGET of 400 thus it must return the corresponding incentive amount of 500
Please see my screenshot example, I want to add a column to the table next to NETT TX COUNT called TX COUNT INCENTIVE ACHIEVED, which must pull from the table on the right of the screen shot
