Forum Discussion
Count rows that match a certain string from a column
Hi,
I want to count rows that contain a certain value from a long string in a column
Table
id meta
1 apples_abc_def
2 mangoes_abc_def
Count rows where meta contains apples
How do I write this is dax? I tried search function but it did not work.
- =calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)
1 Reply
- =calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)