Keeping some page filters but not month selection

[abigail11]

I currently have the measure below which calculates the cumulative total of target hours, displayed in a line chart. My issue is when the page is filtered on a specific month, for example January - as other visualisations on the page require this - the line chart updates to only show January, whereas I need it to continue to show the full year through to December regardless of the selected filter value. It is worth noting I have other slicers / filters on the page which I need to keep impacting this chart.

Any help would be very much appreciated - I'm pretty new to PowerBI!

Cumulative Target =

   CALCULATE(

        SUM('Hours'[Target Hours]),

       filter(ALLSELECTED('Hours'),'Hours'[Month] <= MAX('Hours'[Month]))

)

[Anonymous · Accepted solution]

Hi @abigail11  , 

I tried to use a sample data myself based on your requirement and implemented the result. Please check if there is anything that can be improved. Here are the steps:

1.Load example data for demonstration:

2.Create a line chart visual and measure:

measure = 
CALCULATE(SUM(financials[ Sales]),FILTER(ALLSELECTED(financials),'financials'[Month Number] <= MAX('financials'[Month Number])))

3.Creating a new table based on the month field avoids the need to perform filtering operations on line charts as well, by using the month in that table as a slicer field for other visuals.

4.When using other visuals, the following dax code can be written to create the measure, which will use the month of the new table:

Measure 2 = 
CALCULATE(SUM(financials[COGS]),FILTER(ALLSELECTED(financials),'financials'[Month Number] = SELECTEDVALUE('Table'[Month Number])))

4. The final  results obtained are as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!