Forum Discussion
aeinc01
3 years agoFrequent Visitor
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)
| Name | Status |
| Leah Potok | Recieved |
| George Tyson | Recieved |
| Harry Girma | Recieved |
| Robert Birch | Rejected |
| Luis Sacks | Terminated |
1 Reply
- Manoj_NairSolution Supplier
aeinc01 - try this DAX, let me know if this work is for you.
Accept as Solution if this resolve your query