Forum Discussion
Simple count but with multiple variables in the column
Hey guys so my issue is that I have a table of lets say 3 counties A, B and C. And another table that has a row a column of "Contries for" but in this table you could have more than one contry listed...
Anonymous
Try this MEASURE
Measure = COUNTROWS ( FILTER ( Table2, SEARCH ( SELECTEDVALUE ( Table1[Countries] ), [Countries For], 1, 0 ) > 0 ) )
Zubair_Muhammad
Thanks for your quick reply but I am still getting the same result, using your formula.
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
Please check attached file with your sample data