Forum Discussion
NourJ
3 years agoHelper III
Constraint values in multiselect slicer
Hi, This is my second post on this topic I hope I will get an answer as I didn't receive any for the previous one, My issue is with the multi-select slicer should be conditioned some values in my...
Sahir_Maharaj
3 years agoSuper User
Hello NourJ,
Create a measure that checks if the selected values in the slicer contain either "A" or "B" and if they do, the measure will remove "D" from the selection. Similarly, if the selected values contain "D", the measure will remove "A" and "B" from the selection.
Selected Values =
VAR SelectedValues = VALUES(Table[Column])
RETURN
IF (
CONTAINSSTRING(CONCATENATEX(SelectedValues, Table[Column], ","), "A")
|| CONTAINSSTRING(CONCATENATEX(SelectedValues, Table[Column], ","), "B"),
EXCEPT(SelectedValues, VALUES(Table[Column]), VALUES(Table[Column]) = "D"),
IF (
CONTAINSSTRING(CONCATENATEX(SelectedValues, Table[Column], ","), "D"),
EXCEPT(SelectedValues, VALUES(Table[Column]), VALUES(Table[Column]) IN {"A", "B"}),
SelectedValues
)
)
I hope this helps! Let me know if you have any further questions.
NourJ
3 years agoHelper III
It doesn't work unforturnatly