Ignore filter context minus date

[Anonymous]

Hello, I have a problem, can you help me?

I have a graph of grouped columns and rows, and I am putting on my secondary Y axis the measure 'targetss" which should return me a straight line, but because of the filter context it brings a crooked line.

the use of all and allselecetd were not so good, as they returned my entire data period, and I only want "this month".
I tried this dax

Targetsss =
CALCULATE([Weighted PPH Target], FILTER(ALL(dDate_Periods), dDate_Periods[Period] = "This Month"))

But it doesn't succeed, it still returns the total context.

Look at the example below:

Chart:

Columns being used:

Ruling filter on the page:

[MFelix]

Hi @Anonymous ,

What is the value of "This Month" is a column with the current month on your calendar table?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.