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 All,
I need to count the lines with specific word in a column containgingdiferents words.
I though to do something like:
data1 = countx ( filter( table, table[column] = "*wordtofind*"), [column to count])
This measure working only if the wordtofind is the only value in the cell.... but I wanto to count also if part of a sentence or part of long word.
May help me?
Thx
Solved! Go to Solution.
Hi, @Mgg
use something like this:
Activated = COUNTROWS(FILTER('Table', CONTAINSSTRING('Table'[Company], "See")))
This will look for "See" in Column "Company" in table "Table".
Hi, @Mgg
use something like this:
Activated = COUNTROWS(FILTER('Table', CONTAINSSTRING('Table'[Company], "See")))
This will look for "See" in Column "Company" in table "Table".
I'm not sure is exactly what I need.
Looking in the following table I need to count the number of Prj if in column type there is the word see ...also if combine with other.
The result should be 3....so the yellow onr 🙂
Thx
Hi, @Mgg ,
CALCULATE(
COUNTROWS('Table'),
CONTAINSSTRING('Table'[Company], "See") && NOT (ISBLANK('Table'[Prj]))
)
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |