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 ) )
Community ChampionAnonymous
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
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
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!