When you use the filter criteria "Membership is _" and "Membership status is _" in conjunction with one another, both all of the memberships of that type as well as all of the memberships of that status populate. This prevents users from being able to use the filter tool to pull up only members with a certain status for any given membership type.
The workaround is to use the "Membership types" page to export data with accurate numbers by status. However, users with custom permission sets may not have access to their nation's Settings tab and are thus prevented from utilizing this workaround.
UPDATE 2/9/17: We have learned that this issue is related to the status of the membership. For example, if you use the filter here:
The filter will show results for profiles that contain the membership "Cooktastical Cook" and any other membership marked with a status of "Active". Example, this user shows up with the above filter:
The image above shows that the specific membership of "Cooktastical Cook" is expired, but in general, the profile does meet the criteria because it has a membership status of active (for the Party Princess membership in this case).
This is something we will consider but does not have a timeline at the moment.
However we are paying close attention to the most popular suggestions so please share and encourage others to follow and comment!
Another similar suggestion for filter scoping is 'date range filter for donations' is also worth following!
A potential alternative option would be to use the "Membership types" page to export data with accurate numbers by status. As a fair warning, users with custom permission sets may not have access to their nation's Settings tab and may be prevented from utilizing this workaround.