Forum Discussion

AnthonyTilley's avatar
AnthonyTilley
Solution Sage
6 years ago
Solved

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 intege...
Need Help
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    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], ",")

d_gosbell's avatar
d_gosbell
Super User
6 years ago

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], ",")