Forum Discussion
Simple count but with multiple variables in the column
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
After playing around with my relationships it seems your answer is correct iff my two tables are unlinked in my relationship model. However if they are linked I get the same problem. Could you help explain why this is so? As I do not want to create a whole new unlinked redundant table just for this calculation.
- Zubair_Muhammad
Community Champion
Anonymous
If they are linked somehow, i believe you can use ALL function to remove the FILTER context
Measure = COUNTROWS ( FILTER ( ALL(Table2), SEARCH ( SELECTEDVALUE ( Table1[Countries] ), [Countries For], 1, 0 ) > 0 ) )Zubair_Muhammad
Yes worked perfectly!I am trying to wrap my head around the thought process of this function, if you coud describe how it works would be much appreciated!
- Zubair_Muhammad
Anonymous
This formula is just filtering Table 2 where the string/text (selectedvalue of Table1[Countires]) is found
Then it Counts the rows of filtered Table2
so for the first Table Visual calculation, it works like this
Filter(Table2 , Where Country A is found in column "Countries For" of Table2)
then
Countrows of above filtered table