Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |