Forum Discussion
SELECTED VALUES Ignore some values
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
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], ",")
1 Reply
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], ",")