Calculating NPS scores

[voldeckm]

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!

[voldeckm]

[voldeckm]

pbix

[Ashish_Mathur]

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.