aggregate per category keeping filters, using calculated column or new table

Hello,

I have a customer-per-month dataset, and i need to create a calulated column (not measure) where for each customer returns an aggregation of its total turnover. The tricky part here is that i need to have a slicer in my dashboard, where the user selects specific months to be included in this calculation.

Please note that it need to be a calculation in column, not a measure, because i need to use this numbers as axis in a scatter chart.

I tryed a calculated new table having both ways connection with my primary customer-per-month table, on customer_id . It did returned on customer level the required aggregation, but it partially ignored the slicer, as it was containing total turnover, of the correct month's customers.

My code was the following: