Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |