Customer Satisfaction Index (CSAT) dynamic calculation

hi Anonymous 

For [Importance weight] and [Weighted value], you could create two calculated columns by these formula

Importance weight = 'Table'[Importance]/CALCULATE(AVERAGE('Table'[Importance]),ALLEXCEPT('Table','Table'[Feature]))

Weighted value = 'Table'[Importance weight]*'Table'[Rating]

For [Appraisal_mean], [Importance_mean], [Weighted_mean] and [CSI], you could create Calculated measure as below:

Appraisal_mean = CALCULATE(AVERAGE('Table'[Rating]),ALLEXCEPT('Table','Table'[Feature]))

Importance_mean = CALCULATE(AVERAGE('Table'[Importance]),ALLEXCEPT('Table','Table'[Feature]))

Weighted_mean = CALCULATE(AVERAGE('Table'[Weighted value]),ALLEXCEPT('Table','Table'[Feature]))

CSI = AVERAGEX(VALUES('Table'[Feature]),[Weighted_mean])/10

Result:

and here is sample pbix file, please try it.

Regards,

Lin