Try the following steps in order until the issue is resolved: 
  1. Duplicate memberships showing in query when there is more than one member: Add the criteria of Members\Primary member is equal to yes to only show one membership per query row.
  2. Cancelled memberships are showing in the query: Add the criteria of Member\Memberships\Status is not equal to Cancelled.
  3. Members who are no longer on the membership are showing in the query: Add the criteria of Members\is dropped is equal to no.
  4. Output Member\membership\Membership Transaction\Action to compare the number of actions to the action in the Activity Tab to determine where you are off.