ignoring date filter on page

[vanessafvg]

I have a dashboard that is filtered by the last reported date.

however i want to show all the status for a project over a the last year, how do i ignore that filter report date on the dashboard to not apply to this one visual.  

this is my calculated column value but its not working, its not ignoring the date filter on thage page

RAGs This Year = CALCULATE(VALUEs(Rag[Rag Status]), FILTER(all('Date'), 'Date'[Year] = year(TODAY())))

in the table i can see this is working, but when i add it to the visual it still removes all other dates

[v-danhe-msft]

Hi @vanessafvg,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[vanessafvg · Accepted solution]

@v-danhe-msft  sorry it looks like i double posted, as i said for visual i just set interactions not to filter for this particular visual problem sorted quick, thanks for the response though.

[v-danhe-msft]

Hi @vanessafvg,

Based on my test, you could create a measure instead of a calculated column:

Sample data:

Create a measure:

Measure = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),MONTH('Table1'[Date])=MONTH(TODAY())))

Result(I have set the page filter):

Regards,

Daniel He

[Stachu]

can you share sample data?
in general calculated column should not be affected by slicers, so I think you will need measure