The Net Promoter Score (NPS) is a metric that is based on responses to the question, "How likely is it that you would recommend our company/product/service to a friend or colleague?" The response to this question is generally scored on a scale from 0 to 10, with 0 being highly unlikely and 10 being very likely. The NPS is a registered trademark of Fred Reichheld, Bain & Company, and Satmetrix.
Responses to the question are categorized into the following groups:
- 0 - 6: Detractors
- 7 - 8: Passives
- 9 - 10: Promoters
The formula used for the NPS subtracts the percentage of detractors from the percentage of promoters and returns a value from -100 to 100.
This recipe demonstrates how to calculate the NPS using DAX.