Count to ignore all filters including related tables

[jtpiazzamn]

I need to count the number of ID # in a table without any filters. 

# of users = Calculate(Count('User List'[User.id]), ALL('User List'))

This works, however, whenever I apply a Page filter that has a filter from a related table, it filters my measure # of users. 

The relationship between the 2 tables are not direct, but all relationships are setup as both ways. I thought this might be affecting the result of the measure. 

I have tried many variations which all work, but when I apply the page filter it still filters my measure. I'm essentially looking to count the number of rows of the User List table without any filter. I have used the CountRows function, but the page filter still is affecting the measure. 

Thanks in advance. 

Jim

[Greg_Deckler · Accepted solution]

@jtpiazzamn Unfortunately page level filters pre-filter the data so that those rows aren't even available to DAX. You will have to move your page filter to visual level filters instead. Or, inactivate the relationship and use USERELATIONSHIP in any calculations where you need it.