Assume I have users in a system. I track the users that login (so I join from users to logins) and I track pages they view in a system (join from logins to pageviews). How can I build a calculation on the distinct list of logins to calculate which users have been active in the system?

Right now I have an "Active Count" calculated filed: IF [status] = 'active' THEN 1 ELSE 0 END but when you add that as a measurement it counts each pageview and doesn't take into account the unique logins.

Thanks for the help!