dax error, return no value

[Anonymous]

I want to make a silmilar selection, 
dimtable is 

TA
JPT

dan facttable column is like this

TA_a
Jpt

there is no common column to build a relationship, I want to make a slicer use dimtable to filter factable

here is the DAX:

ChannelFilter =

VAR dim =

VALUES('dim'[dim] )

VAR facttbl =

VALUES('facttable'[describe])

RETURN

IF ( SEARCH ( dim, facttbl,, 0 ) > 0, facttbl, 0 )

no matter how I tried, it returns only 0, how to make this DAX correct?

I want to use dimtable slicer  to filter factable all the columns, do you have any good ideas?

[sturlaws · Accepted solution]

Hi,

write your measure like this:

and add it to the filterpane of the visual, and set it to greater than 0:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[Anonymous]

very good😺