Forum Discussion
dax error, return no value
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?
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.
2 Replies
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.