Measure to exclude slicer selection from results

[Melodyv]

Is there a way to have a visual show all results EXCEPT from the selection in a slicer? 

Below is what I have.  I need the visual to show all results EXCEPT the program selected in the slicer.  I can't just use edit interactions because I do want the visual to be filtered by the selected program in the slicer - I just don't want that program to appear again in the results.  So in the example below, I want all those programs to appear as they are (which is filtered) but do NOT want "CMCA_FOC" to appear in the visual.

The "Program" field in the slicer comes from a sheet titled "Module B Detail Report."  The data in the visual comes from a sheet titled "Module B Detail - Enrolled Programs."  

I have tried creating a measure in the sheet "Module 4B Detail - Enrolled Programs" following this post, but it does not seem to be working for me.  The "Duplicate for Filter" sheet is a copy of "Module B Detail Report."  Here is the measure I created:

Measure = IF(ISFILTERED('Duplicate for Filter'[Program]),IF(MAX('Module 4B Detail - Enrolled Programs'[Program]) in ALLSELECTED('Duplicate for Filter'[Program]),1,0))

Is the measure I'm using the correct measure?  Am I duplicating the wrong sheet?  I appreciate any help.

[Bibiano_Geraldo · Accepted solution]

Hi, @Melodyv ,

Try to replicate this logic:

1- Create a disconected table with unique values of your program, something like this:

dim_Program = VALUES('Sales'[Program])

My generated table will look like this:

Now make sure that they are NOT related:

Now create a measure to ignore selected value by this DAX:

Sales Amount = 
IF(
    SELECTEDVALUE('dim_Program'[Program]) = SELECTEDVALUE('Sales'[Program]),
    BLANK(),
    SUM('Sales'[Sales Amount (Actual)])
)

Now add a slicer with program colum from previous created table 

Now add a char but here in y-axis place the program column from sales table

Your finaly result should look like this, notice that the selected value in slicer is ignored on the chart:

 

[Shivu-2000]

Hi @Melodyv 

Please update the measure to 
ExcludeSelectedProgram =
IF(
NOT(SELECTEDVALUE('Duplicate for Filter'[Program]) = MAX('Module 4B Detail - Enrolled Programs'[Program])),
1,
0
)

and apply it on visual as a filer.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[Melodyv]

Updating the measure appears to be hiding all results for that visual.  Am I missing a step?