Forum Discussion
Solved
CountROW contains multiple text strings - single column
Greetings, My data set concatenates multiple field values into a single cell where they appear in the same record. However, there are two variants of each value. Trying to create a count mea...
tamerj1
Community Champion
Community ChampionHi stvitus
First you need to manually create a disconnected table that contains all the unique values ("Blue car", "Ref Truck", ect.) to be used as a slicer. Then the CountMeasure would be
CountMeasure =
COUNTROWS (
FILTER (
'Table',
NOT ISEMPTY (
FILTER ( SlicerTable, CONTAINSSTRING ( 'Table'[Product], SlicerTable[Value] ) )
)
)
)
you can also place it in the filter and filter is 1 or is not 0