Forum Discussion

aeinc01's avatar
aeinc01
Frequent Visitor
3 years ago

Trying to Calculate Retention Rate

Hi, I'm currently trying to calculate retention rate, but I'm currently running into errors since I'm not yet familair with the process.

 

Currently I have:

 

Retention Rate =

DIVIDE( Calculate(Count('Table13'[name]), FILTER( 'Table13', 'Table13'[Status]="Recieved"))

-( Calculate(Count('Table13'[name]), FILTER( 'Table13', 'Table13'[Status]="Rejected" AND "Terminated")

,

DIVIDE( Calculate(Count('Table13'[name]), FILTER( 'Table13', 'Table13'[Status]="Recieved"))

)

 

The Equation is suppose to look like :

Retention Rate = (Total Recieved)-(Rejected+Terminated)/(Total Recieved)

NameStatus
Leah PotokRecieved
George TysonRecieved
Harry GirmaRecieved
Robert BirchRejected 
Luis SacksTerminated

1 Reply

  • Manoj_Nair's avatar
    Manoj_Nair
    Solution Supplier

    aeinc01 - try this DAX, let me know if this work is for you.

    Accept as Solution if this resolve your query