Need to create a Measure to place it at visual level filter

[Anonymous]

Hi Team,

Need help to create a measure which i will be using as visual level filter on a Report. 

 I have a customer table with customerid, I dont want to create calcualted column but make use of mesaure.

Code logic that i would like to have in measure.

Customerid not in ('1234',2345',3452',2647',2348')

Any help is highly appreciated.

Thanks in advance.

[amitchandak]

@Anonymous , Try a measure like

calculate(sum(Table[value]) , filter(table, not(Customerid in {"1234","2345","3452","2647","2348"})))

[Greg_Deckler]

@Anonymous - Perhaps:

Measure =
  VAR __CustomerID = MAX('Table'[CustomerID])
  VAR __Table = { '1234',2345',3452',2647',2348' }
RETURN
  IF(NOT(__CustomerID IN __Table),1,0)

IDK, I mocked up both in a sample file and both seem to work. You can just filter on the 1 or the 0. See PBIX attached below sig. You want Page 3, Table (3).

[Anonymous]

Hi @Greg_Deckler ,

Thanks for quick response.

The measure outputs is showing as 1 for all the values in the list if i use Not function. My desired out put is the customerid column should eliminate those values present in the list.

If in a table visual, if I place customerid columns from table and the measure , it should show me those values that are not in the list. 

Hope my requirement is clear. 

[Greg_Deckler]

How about:

Measure 3a = 
  VAR __CustomerID = MAX('Table (3)'[CustomerID])
  VAR __Table = { "1234","2345","3452","2647","2348" }
RETURN
  IF(__CustomerID IN __Table,0,1)

IDK, I mocked both up in a file (attached below sig) Table (3), Page 3. Maybe because your stuff are numbers 1234, 2345, 3452 instead of text?