Dax to Ignore Specific Slicer

[spenceratchison]

Hello,

I am attempting to create a measure that is responsive to a specific slicer, but not another. I will include screenshots to illustrate my issue.

As you can see, this is functioning properly as the card is displaying the corresponding defensive value in the table for the slicer selection. I will now include a screenshot when a team is selected in the other slicer.

The value goes to 0 whenever I select a team from both slicers and I am wanting my calculation to ignore the second slicer. I am aware that I can edit the interactions of the given slicer to have it not impact a specific visual, but I am planning on referencing this measure within other measures, so I can't have this other slicer impacting the value that it calculates. My current measure is 

Test Away Defense = IF(SELECTEDVALUE(Schedule[Away Team])=BLANK(),0,Calculate([Defensive Elo - Away Table],'Away Team Table'[Team] = SELECTEDVALUE('Schedule'[Away Team]),REMOVEFILTERS('Schedule'[Home Team]))). I thought the REMOVEFILTERS function would prevent that slicer from impacting my calculation, but it doesn't seem to be working that way. I appreciate the suggestions in advance!

[marcopaz]

This solution helped me a lot with my problem as well. Thank you so much

[danextian · Accepted solution]

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] )
)

[WTAS80486]

Hi @danextian Could you help with this scenario

I need to use finish date and reported date from the same table. create a measure to calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP or CLOSE) . should change with finish date slicer  but not with reported date slicer. both these measures have to be used in a column chart to show total orders and completed orders