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.

     

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.