topic Re: Need to create a Measure to place it at visual level filter in DAX Commands and Tips

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

Anonymous — Sun, 30 Aug 2020 18:43:53 GMT

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.

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

Greg_Deckler — Sun, 30 Aug 2020 19:25:45 GMT

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).

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

Anonymous — Sun, 30 Aug 2020 19:05:42 GMT

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.

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

Greg_Deckler — Sun, 30 Aug 2020 19:27:47 GMT

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?

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

amitchandak — Mon, 31 Aug 2020 06:52:28 GMT

Anonymous , Try a measure like

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