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 (no reppition) and delimited by a comma. As shown below:
(Did it on excell just to show what I mean)
So what I did was use a simple count measure on "Countries For" and when I try to tabulate it, it is just taking the rows with multiple countries as "Other" as represented by the blank row in the results I get. My question is how can I make it count every country in the coulumn.
Anonymous
Try this MEASURE
Measure = COUNTROWS ( FILTER ( Table2, SEARCH ( SELECTEDVALUE ( Table1[Countries] ), [Countries For], 1, 0 ) > 0 ) )
9 Replies
- Zubair_Muhammad
Community Champion
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
Anonymous
Please check attached file with your sample data