Forum Discussion

voldeckm's avatar
voldeckm
Regular Visitor
3 years ago

Calculating NPS scores

Looking for some help with the correct formula(s) to calculate NPS scores.

 

Currently I have the following formula for promoters and detractors which weights fields where Q45 is 0-7 and Q5 is Yes :

NPSBM_Detractor = CALCULATE(SUM(FinalDataSet[Weights_Q1_Q2_Q3_Q4]), (FinalDataSet[Q45] IN {0, 1, 2, 3, 4, 5, 6, 7}) && (FinalDataSet[Q5] == "Yes"))
 
Then I attempt to calculate the NPS score with this formula:
NPSBM_score = ([NPSBM_Promoter]/[NPSBM_Total_Voter]) * 100 -
([NPSBM_Detractor]/[NPSBM_Total_Voter]) * 100
 
The expected NPS result for the screenshot below is 25, however the score shows as 27.26. IS there a mistake in the formulas above? Is there a better way to calculate this score? Thanks in advance!
Tips and Tricks

3 Replies

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      That is a maze of measures to go through.  For rail, the result of your "NPSBM_Via_Rail_Total_Voter" measure is 1230.  However the 25% and 45% are being calculated with a denominator of 1308.391.  Please check the filter conditions of the "NPSBM_Via_Rail_Total_Voter" measure.