How to obtain the multiple correlation coefficient (R)

[kishcolor]

I use the following article to calculate variables, standard errors, t-values, and p-values using R script.

https://stackoverflow.com/questions/48796873/multiple-linear-regression-in-power-bi

Using these calculated values,

I want to find the multiple correlation coefficient (R), the multiple determination coefficient (R2), and the corrected R2 value.

Most of the methods to calculate with DAX or quick measures use two variables, and I don't know how to calculate when there are three or more like this.

How can I use the values of these variables in R script or DAX to find the multiple correlation coefficient?

If anyone has any good ideas, could you please let me know.

Best regards.

[v-henryk-mstf · Accepted solution]

Hi @kishcolor ,

The correlation coefficient is a statistical measure of the relationship between two variables; these values range between -1 and 1. 

There is no more documentation or information available to calculate correlation coefficients between more than two variables in powerbi.

For more details, you can read related blog as below.

Correlation Coefficient in Power BI using DAX - Ben's Blog (datakuity.com)

Power BI - looking for correlation - Michal Molka - Medium

How To Get Correlation Coefficient In Power BI (c-sharpcorner.com)

If the problem is still not resolved, point it out. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.