Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ignore filter context minus date

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:

 

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    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.