Correlation coefficient quick measure between two measures

[jewels]

Hi all,

I am trying to establish the correlation coefficient between two measures of my dataset. The columns these measures are based on are customer satisfaction scores from 1-10 in different categories, rows are customer surveys.

These measures calculate the percentage of values ranking on a certain scale (1-10), namely the scores of 8, 9 and 10s, so the measure would come back with a percentage of all customers scoring different areas of my service with the three top scores (this is how we establish our customer satifsfaction).

Now I want to establish whether there is a correlation between two of those scores (=measures). I am using the "correlation coefficient" function in the Quick measures and am grouping the surveys by hotels in the "category" field with both measures in the X and Y axis fields. 

When I run the correlation, the value it comes up with is -1.97 instead of a value between -1 and 1.

Any takers on this? Would greatly appreciate help on this 🙂

Julie

[jewels]

Dear @v-xiaoyan-msft , many thanks for your response, I really appreciate you took the time to help me.
I do understand why the value has to be between -1 and 1, hence why I am all the more surprised that the measure does not come up with a value in that range. So I have no explanation why the function in PowerBI does not work for my analysis. I suspect it has soemthing to do with the fact that I am trying to use measures for this. Would you be available to talk through this on a call? I would greatly appreciate your help.
Thanks,

Julie

[v-xiaoyan-msft]

Hi @jewels ,

The Correlation Coefficient cannot be greater then the absolute value of 1 because it is a measure of fit between two variables that are not affected by units of measurement.

A correlation coefficient is a measure of how well the data points of a given set of data fall on a straight line. It tells you if there is a linear relationship between the two variables involved (It is possible for two variables that are related but not linearly to have a correlation coefficient of zero).

A correlation coefficient of -1 says that there is a perfect negative linear relationship, and a correlation coefficient of +1 says there is a perfect positive relationship. A correlation coefficient of 0 shows there is no linear relationship present. But correlation coefficients can take values between -1 and +1.

Please check your data and try like this way :

How To Get Correlation Coefficient In Power BI 

Hope it helps,

Community Support Team _ Caitlyn

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