Calculate NPS (Net Promoter Score)

[SaganBigRedDog]

https://community.powerbi.com/t5/Desktop/Trying-to-calculate-NPS-Net-Promoter-Score-via-custom-calcu...

I used the solution in this post to try to calculate NPS from a column ("Respondants") containing "passive" "promoter" and "Detractor" values.  However, each time I try, it comes up blank.  The current formula in the measure is:

NPS =
var NumOfRespon = CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
return
(CALCULATE(COUNTA(Table1[Respondents]), FILTER('Table1', 'Table1'[Respondents]="Promoters")) / NumOfRespon
 - CALCULATE(COUNTA(Table1[Respondents]), FILTER('Table1', 'Table1'[Respondents]="Detractors")) / NumOfRespon)
 * 100

But I continue to receive:

What am I doing wrong?

[v-huizhn-msft]

Hi @SaganBigRedDog,

It's really hard to troubleshooting your issue without sample table, could you please share your sample table or .pbix file for further analysis? In addition, do mask sensitive data before uploading sample table or create dummy table.  Thanks for understanding.

Best Regards,
Angelia