Forum Discussion
How to create average
Hi everyone, I'm trying to find the average NPS score based on the data below, excluding any blanks. Can someone help with creating a formula or solution on how I can get the result in PowerBI? Thanks in advance.
| Ticket Number | Net Promotor Score |
| 1 | Blank |
| 2 | 10 |
| 3 | 10 |
| 4 | 8 |
| 5 | Blank |
| 6 | 9 |
| 7 | 9 |
| 8 | 10 |
| 9 | Blank |
| 10 | Blank |
| Average | 9.3333 |
Assuming in your input table you have literal values 'Blank' then here's how you can exclude them and create a new measure Avg. NPS. (adjust your table and Column name.
Avg. NPS = AVERAGEX(FILTER(Table1,ISNUMBER(VALUE(Table1[Net Promotor Score])) && Table1[Net Promotor Score] <> "Blank"),VALUE(Table1[Net Promotor Score]))If I answered your question, please mark this thread as accepted.
Follow me on LinkedIn:
https://www.linkedin.com/in/mustafa-ali-70133451/
2 Replies
Assuming in your input table you have literal values 'Blank' then here's how you can exclude them and create a new measure Avg. NPS. (adjust your table and Column name.
Avg. NPS = AVERAGEX(FILTER(Table1,ISNUMBER(VALUE(Table1[Net Promotor Score])) && Table1[Net Promotor Score] <> "Blank"),VALUE(Table1[Net Promotor Score]))If I answered your question, please mark this thread as accepted.
Follow me on LinkedIn:
https://www.linkedin.com/in/mustafa-ali-70133451/