I am making a report in which I have to show the take-rates of different items. Each item exists of a three-letter string, and all items are pooled in one and the same column as a large string, separated by spaces.
I am now trying to create a measure such that searches for a specific item in this column and counts in how many entries the string was found. I now that this is possible by creating a calculated column to find the entries that contain that item and then sum this column, however, it would be nice if this is achievable in a measure.
For example, a column could contain
7AX 4U6 4U7
5AZ 6AT 4U6
609 606 543
I would then like to be able to count how many entries contain 4U6 by a measure...
Thanks in advance for your help