Calculating NPS by segments

[Anonymous]

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. 

[Anonymous]

@Anonymous 

Please share the sample pbix. 

Best,
Paul