Forum Discussion
INTERSECT between 2 Tables with different Filter Values
Hi Everyone, I would appreciate any assistance you could provide. I have two tables that share a Many to Many relationship. The first is a record of all activities created by our staff and the secon...
Selva-Salimi
Solution Sage
Solution SageHi kfortenberry
you can write a measure as follows:
measure count_policy := var tbl1= summarize( filter (activities, [activity type] = "TF") , activities [client code])
var tbl2 = summarize ( filter (policies sold , policies sold [client code] in tbl1) , policies sold [ client code] , policies sold [ policy number] )
return countrows (tbl2)
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.