Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a table that contains a text column and a second table that contains a list of keywords. I'm trying to set up a slicer that allows me to filter the text column by the keywords.
I created two measure and added a visual filter to accomplish this. The two measures I have are:
Solved! Go to Solution.
@RobX , the Second one can not be a column. You can create two measures like
SelectedKeyword =
SELECTEDVALUE(
Keywords[Keywords]
)
WordFilterTest =
SUMX(Note,
if(Search([SelectedKeyword ],Note[Note],, 0) > 0, 1, 0)
)
@RobX , the Second one can not be a column. You can create two measures like
SelectedKeyword =
SELECTEDVALUE(
Keywords[Keywords]
)
WordFilterTest =
SUMX(Note,
if(Search([SelectedKeyword ],Note[Note],, 0) > 0, 1, 0)
)
How are these used? WordFilterTest added as filter greater than 0? What about the other?
That fixed it! Thank you!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.