If one calculates the Attrition & Reactivation right on a view
(via Table Calculations), then the counting/filtering could be done
on the same view, too (using a pair of Nested Table Calculations).
BTW, with the data like yours (when there are rows with the [Status] = 0)
it could be possible to use LOD expressions (instead of Table Calculations) for the same.
Please find the attached (with the former approach).
Hope it could help a bit.