Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
EsterBR
Helper II
Helper II

DAX - not apply slicer

Hi,

 

I have the following slicers and a card. 

EsterBR_1-1718363216854.png

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!

 

 

1 ACCEPTED SOLUTION
rajendraongole1
Community Champion
Community Champion

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

View solution in original post

1 REPLY 1
rajendraongole1
Community Champion
Community Champion

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.