Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am rying to create a measure that looks in to a column and if the column includes the value than true
ie
new measure = columnA include/has 'TWO' . Two could be in a sentence with 10 to 20 words
id ColumnA
1 one,two,three,four,five,six.seven
2 one,one,five,six,six,ten
3 six,seven,eight,five,six
so the new measure should return 1
I hope that make sense
thanks
Solved! Go to Solution.
@Anonymous,
Learn the function by links below.
@Anonymous,
You may try the measure below.
Measure = VAR s = "TWO" VAR d = "," RETURN COUNTROWS ( FILTER ( Table1, SEARCH ( d & s & d, d & Table1[ColumnA] & d, 1, 0 ) > 0 ) ) > 0
thanks
thanks for the respond,
I am not sure if I undrestand the " d & s & d, d & Table1[ColumnA] & d, 1, 0 ) > 0 " part , could you please explain briefly , thanks
@Anonymous,
Learn the function by links below.
Thanks