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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
LYeo87
Helper II
Helper II

Create a measure that doesnt get effect by slicers on that page

Hello,

 

How can i adapt this measure so that it isnt affect by any of the slicers on this page? I don't want to edit the visual, but the measure itself.

 

1) = DISTINCTCOUNT('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID]
1 ACCEPTED SOLUTION

Hello, than you - i only wanted to avoid one slicer actually in the end - i think iv got there with this:

2) AUDIT ITEMS DISTINCT COUNT NO RESULT FILTER) = CALCULATE([1) AUDIT ITEMS ID DISTINCT)],REMOVEFILTERS('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item Result]))

View solution in original post

5 REPLIES 5
MasonMA
Memorable Member
Memorable Member

Hello @LYeo87 

 

Not sure if i get your request 100%. 

 

Usually to make your DISTINCTCOUNT measure ignore all slicers/filters on the page, modify it using REMOVEFILTERS (or ALL) to clear any external filter context.

 

For example if you'd like to ignore all filters, use

Measure = 
CALCULATE(
    DISTINCTCOUNT('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID]),
    REMOVEFILTERS()  
)

 Or specific table/column use

Measure = 
CALCULATE(
    DISTINCTCOUNT('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID]),
    REMOVEFILTERS(
        'table1',  // Ignore filters on table1
    )
)

 

You may also need to use KEEPFILTER('Table'[Column]) with REMOVEFILTER() to reapply Filter of this 'Column'.

 

Also in some cases, the simplest way to prevent a visual from being filtered by slicers would be to edit the visual interactions under 'Format', but it depends on how your Measure is used in Visual. 

 

Hope this helps:) 

Thank you for your help

johnt75
Super User
Super User

You can use REMOVEFILTERS to remove all the filters from a calculation

Count =
CALCULATE (
    DISTINCTCOUNT ( 'Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item ID] ),
    REMOVEFILTERS ()
)

Thank you for your help

 

Hello, than you - i only wanted to avoid one slicer actually in the end - i think iv got there with this:

2) AUDIT ITEMS DISTINCT COUNT NO RESULT FILTER) = CALCULATE([1) AUDIT ITEMS ID DISTINCT)],REMOVEFILTERS('Dynamics - Pbi HSE_Audit_Inspections_LC'[Audit Item Result]))

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.