Ignore filter

[azaterol]

Hello everybody,

I have a problem with my visuals. 

If I use the slicer and choose beetween the employees, the total sales changes to the sales how much the employee is made total. 

Also the sales from 2022 is changing to the employee sales, she made total in 2022.   

Here is my DAX for 2022.

Sales 2022 = Calculate(SUMX(VALUES('Date'[Year]),[Sales]),FILTER('Date','Date'[Year]=2022), KEEPFILTERS(Employee))

I want that if the end user of this report is changing between the employees, the sales visual has NOT to be change. It has to show still the total sales. 

Thank you for your help 

--azaterol

[Anonymous]

Hi,

For the measure on the global sales visual, jsut make a new measure and remove filters on employee

[azaterol]

Hey @Anonymous , 

sorry I didn't understand that. Could you please explain clearly?

Thank you 

[v-easonf-msft · Accepted solution]

Hi, @azaterol 

If you just want to keep the chart unaffected by the slicer, change the interaction behavior between the slicer and the visual.

Change the interaction behavior 

If you only want the values in some columns not affected by the slicer, such as the sales from 2022, please add a new formula as below.

New Sales 2022=Calculate([Sales 2022],ALL('Table'[Employees]))

Best Regards,
Community Support Team _ Eason