Hello,
I have calculated NPS (Net Promoter Score) using measures in Power BI Desktop. This is an overall measure for all data. I would like to calculate NPS, for example, for a column containing lots of categories. Is there any way to automate calculation of NPS just by using the name of the column containing segments (categories)? Ideally, I would get the following output.
Respondent number Response (0-10) Overall NPS Reason for purchase NPS for Reason for Purchase
1 8 55 easy to use 36
2 9 55 easy to use 36
3 7 55 easy to carry 30
4 8 55 easy to carry 30
5 6 55 easy to maintain 28
6 7 55 easy to maintain 28
I would need to come to NPS for reason for Purchase based on Response and Reason for Purchase.
Is there any syntax that could help on this? Do I do it in Power Query or using DAX?
I could share a sample data if needed.
Thanks in advance.
