Need to know more about filtering on active members

Am filtering a custom view on members who are active in Member 2.
I.e. show only
ms_is_member is a boolean equal to 1
but is shows all members that have had membership, even if they are cancelled, or otherwise not active.
I need to know the equivalents of active and not cancelled, not deactivated, so that the filter works properly. Please advise.