Forum Discussion

LeanneShapro's avatar
LeanneShapro
Advocate 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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

My NPS formula:

NPS Score =
  VAR ResponseCount = COUNTA(SurveyResponse[Answer])
  VAR PromoterCount = COUNTAX(FILTER(SurveyResponse, [Answer] >= 9), [Answer])
  VAR DetractorCount = COUNTAX(FILTER(SurveyResponse, [Answer] <= 6), [Answer])

  VAR Score = 0 + (PromoterCount - DetractorCount) / ResponseCount * 100

  RETURN IF(NOT(ISBLANK(ResponseCount)), Score)
  • rayinOz's avatar
    rayinOz
    Helper III
    5 years ago

    Hello

     

    Thanks for the NPS formula. In my table I have different course names [module] which is text. How do I add in a filter so the NPI score is filtered by course names? 

     

    Thanks!

    Ray