cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

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?
1 ACCEPTED SOLUTION
sturlaws
Resident Rockstar
Resident Rockstar

Hi,

write your measure like this:

sturlaws_1-1654166200020.png

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

 

sturlaws_0-1654166124964.png

 

 

Cheers,
Sturla

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

 

View solution in original post

2 REPLIES 2
sturlaws
Resident Rockstar
Resident Rockstar

Hi,

write your measure like this:

sturlaws_1-1654166200020.png

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

 

sturlaws_0-1654166124964.png

 

 

Cheers,
Sturla

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

 

Anonymous
Not applicable

very good😺

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors