Forum Discussion

Melodyv's avatar
Melodyv
Icon for Helper I rankHelper I
1 year ago
Solved

Measure to exclude slicer selection from results

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...
  • Bibiano_Geraldo's avatar
    1 year ago

    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: