Forum Discussion
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...
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.
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?
This is a DAX expression and not to use in Query Editor. Once you are done in query editor, add new MEASURE.