Make Meaure Ignore Filter and Sum by Date

[JAlarco]

Hi, 

I have a date table and I have a column that I wish to sum and ignore a page level filter for the date. There is a relative date filter set to the last day on the page. 

However, I would like to still display the sums by date in a line chart for 3 days, ignoring the relative date filter set for the previous day. Is this possible? 

The issue I am running into is that the CALCULATE(SUM(column), date_filter)) function sums the the column for the time period but the date associated with the sum is a single date. 

What I want is output to be is the sum by date in a line chart, so I would have:

2/19/23 4

2/18/23 5

2/17/23 6

In the form of a line chart with date along the x-axis and sum along the y-axis.

Instead, I am getting: 

2/19/23 15

(This is the sum of the column in the time period I filtered on in the CALCULATE function, but it sums the entirety for the period to a single day. 

Is there to have it display the sums of the column by day in a line chart rather than sum them completely?  

[JAlarco]

I found a solution, in case anyone ever sees this in the future. 

I have a model with several tables connected to one dim date table. 

Instead of using the dim date table for the chart or a calculate formula, I used the original date in the fact table and turned off cross-filtering and simply summed the column by date. With this, I was able to ignore the page level filter on the date. 

An alternative method would have been to use a slicer instead of a page level filter and disable interaction in the slicer format > edit interactions toolbar with the line chart.