SELECTED VALUES Ignore some values

[AnthonyTilley]

Hi All,

Looking for a simple way to retrive the selected values from a filter but ignore some pretetermind values 

in my example i have a filter that contains a set of integers 

these integers are the identifiers to a set of Data snap shots 

Within the report the user will always select 1 snap shot to display, however by default the report always includes several snap shots that must be included. for example if a user wants to see snap shot 78 then they would select this in the filter.

however when using all selected function it will return snap shot 78,9999,0000,0001 

these three snap shots contain data that is always included in the filter and cannot be removed. 

i am trying to display a title across the top of the page that will tell the user what snap shot is selected 

i can use all selected to get back the list above but not sure how to return onl the 78 and ignore 9999,0000,0001

[d_gosbell · Accepted solution]

ALLSELECTED just returns a table object so you can wrap that in a FILTER
eg.

MyMeasure = CONCATENATEX(
    FILTER(
      ALLSELECTED( 'table'[Column1] ),
      NOT( 'table'[Column1] IN {"0000","0001","9999"} )
    ) , [Column1], ",")