DAX - not apply slicer

[EsterBR]

Hi,

I have the following slicers and a card. 

Table A: Team, Department

Table Calendar: Quarter, month, year

I would like that only the slicer team applies to the card and not the department, quarter, the month and the year slicer.

I have created this formula for the sales KPI: 

Total EAC = CALCULATE(

  SUM(sales),

    REMOVEFILTERS('Calendar Table Query')

)

What can I add to this measure to tell Power BI that the slicer Department doesn´t have to be applied? Thank you so much!

[rajendraongole1 · Accepted solution]

Hi @EsterBR - Add in your measure one more filter as below for department also to remove the filters, i am assuming department field is available in another table , change the table reference as per your model.

Total EAC = CALCULATE(
SUM('Sales Table'[Sales]),
REMOVEFILTERS('Calendar Table Query'),
REMOVEFILTERS('Department Table'[Department])
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!