Correlation Between Two Columns

[Kumar11109]

Dear All, 

I am trying to find a correlation between the number of attempts and the score obtained with each attempt. I have attached a screenshot for a sample of data.  How can I do this using power bi, I tried using scatter plot, but it aggregated the attempt number for each resource. 

Thank You, 

Kumar Ashwarya 

[v-huizhn-msft]

Hi @Kumar11109,

What @Greg_Deckler posted is right, please right click the column->quick measure->Correlation coefficient as follows.



Best Regards,
Angelia

[Kumar11109]

I want to find a correlation with each attempt what are the scores, I don't want to aggregate either of the variables. This correlation option aggregates the values.  Is there any other way? 

[v-huizhn-msft · Accepted solution]

Hi @Kumar11109,

Please see the threads below for your reference.

Correlation coefficient
Creating Correlation

Best Regards,
Angelia

[Greg_Deckler]

Turn off summarization in the fields area.

Also, there is a correlation quick measure.