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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Topjacket
Helper I
Helper I

Distinct Count all except all page filters

Hi

 

Is it possible to distinct count a field, ignoring selected filters but including the "All Pages" filters? I could obviously replicate the All pages filters but I would prefer not to as if they ever change, I will need to remember to change the measures.

 

The basic dax I am using at the moment is below but as I have found out this also ignores the "All Pages" filters

 

CALCULATE(DISTINCTCOUNT(MASTER_DATA[Company]),All(MASTER_DATA))
 
Any tips would be great.
 
Thanks
1 REPLY 1
FreemanZ
Super User
Super User

hi @Topjacket ,

 

what do you mean by "ignoring selected filters but including the "All Pages" filters? "?

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.