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 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.