CO
Size: a a a
CO
EH
CO
EH
EH
LS
OB
KK
KK
V
KK
V
V
EH
CO
CO
CO
CO
Churn, % =
VAR __CUR = DISTINCTCOUNT(Query1[devtodev_id])
VAR __CUR_STEP = MAX(Query1[step])
VAR __PREV_STEP = CALCULATE(MAX(Query1[step]);Query1[step]<__CUR_STEP)
VAR __PREV = CALCULATE(DISTINCTCOUNT(Query1[devtodev_id]);Query1[step]=__PREV_STEP)
return IF(OR(1-DIVIDE(__CUR;__PREV;0)>=1;1-DIVIDE(__CUR;__PREV;0)<0);0;1-DIVIDE(__CUR;__PREV;0))