Dax to Ignore Specific Slicer

Hi spenceratchison ,

You will need to use a separate table that doesn't have a relationship (disconnected table) from your fact tables and then create a measure so  it is filtered according to what is selected in the column from that disconnected table.

Disconnected Table =
//as a calcualted table
DISTINCT ( 'Table'[Slicer Column] )

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] = SELECTEDVALUE ( 'Disconnected Table'[Slicer Column] )
    )
)

OR

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] IN VALUES ( 'Disconnected Table'[Slicer Column] )
    )
)

Alternatively,

You can still create a relationship between your fact table and that calculated table but keep it INACTIVE. Use USERELATIONSHIP to invoke the relationship between the two

My Measure =
CALCULATE (
    [My measure],
    USERELATIONSHIP ( 'Disconnected Table'[Slicer Column], 'Table'[Slicer Column] )
)