How to visualise multiple measures in one chart?

Hi all,

I have a data set about NPS (dependent variable) and drivers (independent variables). I want to create a visualisation to show the average score of driver (y axis) and driver importance (x-axis) which is correlation score of each driver and NPS. These are steps I do in excel:

- Transform driver score to new scale (from 5-scale to 2 scale) with 4, 5 values assigned as 1, others are 0. The new transformated data would be used to calculate driver score. e.g Average score of checkout is 89% means 89% customer agree with checkout

- Then I calculate the correlation score of drivers from 5-scale (skip blanks)

I did it from Excel but want to make another in Power BI

Raw data

Excel

Power BI

I created measures for correlations (1), and transformed drivers to calculate average (2), but not able to combine them into a table as in excel to present data

Is there anyway to present the outputs?

Thank you!

Thanh