Forum Discussion

LeanneShapro's avatar
LeanneShapro
Icon for Advocate I rankAdvocate I
8 years ago

Calculate NPS Score with DAX

Hello Power BI Users -    I use the following excel formula to calculate my NPS score and I'd like to create the DAX equivalent. It should take the percentage of promoters (scores of 9 and 10) minu...
Need Help
Johanno's avatar
Johanno
Icon for Continued Contributor rankContinued Contributor
8 years ago
Hi, I would have created a calculated column using SWITCH so that each row get either promoter, detractor or blank. Then use a measure to count and divide. How does that sound?