Adding new column for the total target

Hi,

I faced an issue and I will happy if I get a help from you.

I want to add new column contains the total target.

My table name is Daily_targets

I have here a column with the Retail targets data 

 

 the daily_targets table has a relationship with Sales table (this table appearing daily sales). the relationship by (column date_branchcode) column

I  configured slicers like this to show the data untill today and it is work correctly in Target TD 

I want to add another column with name ( Total targe) which contain the total retail target data based on the slicer selection

EX: if I select QTD > the data for this column will be the whole retail targets for this quarter

if we in Feb month , the total target column will show jan - feb - mar targets.

I tried many things but the data still apparing QTD (until today).

How I can fixed that to make the data shows all the current Quarter? 

same thing in other filters (MTD, YTD)