Forum Discussion
Correlation Between Two Columns
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
Hi Kumar11109,
Please see the threads below for your reference.
Correlation coefficient
Creating Correlation
Best Regards,
Angelia
4 Replies
Turn off summarization in the fields area.
Also, there is a correlation quick measure.
Hi Kumar11109,
What Greg_Deckler posted is right, please right click the column->quick measure->Correlation coefficient as follows.
Best Regards,
AngeliaI 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?
Hi Kumar11109,
Please see the threads below for your reference.
Correlation coefficient
Creating Correlation
Best Regards,
Angelia
