Dynamic Gauge: Fetch target from table

Hi all, apologies if this question has been asked before, but I've not been able to apply any solution I've found.

I'd like a gauge with a target value that varies by the slicers I've created: month and store.

I thought the easiest way would be to create a table with entries for each store, for each month, and use the target column for the visual.

However, this does not generate the desired result.

Is this a viable approach in the first place?