Forum Discussion

PaulCo's avatar
PaulCo
Icon for Helper II rankHelper II
8 years ago
Solved

Weighted NPS Score

I am trying to create a measure that will calculate the weighted NPS score based on contract value (ACV).   I have a list of customers with their survey scores, null survey scores means there has n...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi PaulCo,

     

    I believe the detractor average scroe should be 0-7 (not 0-6).  You may refer to my solution in this file.

     

    Hope this helps.

     

PaulCo's avatar
PaulCo
Icon for Helper II rankHelper II
8 years ago

I thought about doing it this way but there are also comments in the surveys that we want to display in a table and if we only keep one record for each customer then we would lose the comments.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Gotcha,

 

- add new index column in your original table

- you can create another table as suggested in data model, reference original table and keep the original table as it is. set relationship on both tables on this index column

 

It will get you comments from original table. 

  • PaulCo's avatar
    PaulCo
    Icon for Helper II rankHelper II
    8 years ago

    I think that should work.

     

    However, I calculated the average score using the following expression under the New Column feature on Power BI Desktop.

     

    Average Customer Score = 
	CALCULATE(
		AVERAGE('Table'[Survey Score]),
		ALLEXCEPT('Table','Table'[Customer])
		)

     

    How do I recreate this in the query editor so that I can use the field when once I have removed the duplicates? 

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      This is a DAX expression and not to use in Query Editor. Once you are done in query editor, add new MEASURE.