Formula not working as soon as I select 2 or more values

[GulianiG]

Hi Experts,

My formula below is not working as soon as I select 2 or more values from Segment[Sub-Group] in a slicer

Please suggest, thanks

[GregMarbais · Accepted solution]

Hey @GulianiG SelectedValue only returns a value when there's a single value in the selected column. Here's an article on it: https://dax.guide/selectedvalue/
Depending on what you're doing, you may just need to flip how you do the evaluation
Instead of the SelectedValue line you could do OR("Male" IN Segment[Sub-Group],"Female" IN Segment[Sub-Group]),
But that may depend on what you're trying to accomplish.