DAX Measure to count records in one table but ignore the slicer from another joined table

[Mako75]

I have a complex model, and a portion of which is displayed below. I'm trying to create a measure that counts the number of 'Base IDs' and that can be filtered by specific columns within the attributes table (via filter/slicer). However, a 'Locale' slicer based upon Locale.Locale should not affect the value should it be changed.

I have created the following measure, but unfortunately the value changes if the Locale.Locale slicer is changed:

# Base ID = 
CALCULATE ( COUNT ( Base[Base ID] ), RELATEDTABLE ( Attributes ) )

I have also tried the following measure, but then any slicer/filter applied to 'Attributes' does not work:

# Base ID = 
CALCULATE (
    COUNT ( Base[Base ID] ),
    ALL ( Locale ),
    RELATEDTABLE ( Attributes )
)

 What am I missing?

Many thanks in advance

[MarkLaf · Accepted solution]

I believe the piece you are missing is that you need to modify the filters on the Attributes table, not the Base table. You can do this with CALCULATETABLE. E.g., I think something like this will achieve what you want:

Count_IgnoreLocal =
CALCULATE(
  COUNTROWS( Base ),
  CALCULATETABLE(
    Attributes,
    REMOVEFILTERS( Locale )
  )
)

[Mako75]

Thanks MarkLaf.

Works a treat.

[JoBI]

You can try something like this:

# Base ID = 
CALCULATE ( COUNT ( Base[Base ID] ), CROSSFILTER(Attributes[Identifier Locale Key], Locale[Key]), None )

[Mako75]

Thanks JoBi,

I have tried something similar before, but it doesnt work when applying a slicer etc from the Attributes table.
I am also concerned about the performance as there are more than a millions records in the Attributes table.