Forum Discussion
dax help
I am trying to calculate net churn: (gross churn - reactivations) / base but if reactivations are greater than gross churn, I want it to return 0 so basically the numerator would be someth...
ROG , Please try below DAX
Net Churn =
VAR GrossChurn = SUM('YourTable'[GrossChurn])
VAR Reactivations = SUM('YourTable'[Reactivations])
VAR Base = SUM('YourTable'[Base])
RETURN
IF(
Base = 0,
0,
MAX((GrossChurn - Reactivations), 0) / Base
)