Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago
Solved

Ignore filter

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

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

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

    • azaterol's avatar
      azaterol
      Helper V
      4 years ago

      Hey Anonymous , 

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

      Thank you 

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        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