topic DAX - not apply slicer in DAX Commands and Tips

DAX - not apply slicer

EsterBR — Fri, 14 Jun 2024 11:13:27 GMT

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!

Re: DAX - not apply slicer

rajendraongole1 — Fri, 14 Jun 2024 11:47:02 GMT

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!!