Forum Discussion
Measure to exclude slicer selection from results
- 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:
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!
Updating the measure appears to be hiding all results for that visual. Am I missing a step?