Forum Discussion
Creating Correlation
Thank you for your answers!I find the solution.I created the pearson correlation using DAX.Then i applied the numbers as labels in my Graph.It would be great if DAX had Correl(Excel's function) in DAX.
Thank you for your answers!I find the solution.I created the pearson correlation using DAX.Then i applied the numbers as labels in my Graph.It would be great if DAX had Correl(Excel's function) in DAX.
Having looked at the solutions posted on Correlation in DAX, the method looks like:
Having chosen 2 fixed variables, calculate the appropriate sums of squares and differences with a long formula and then evaluate the ratio to give you Pearson's Correlation. If you have more than one variable, you will be writing custom measures for each of them. The recommendation is to use R for this, probably starting with the Correlation Plot from the Office Store.
https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104380814
Dear Elpida,
According to your post in 2016, I would like to know how you add the correlation indicator.
In my project of world imports statistics, I want to see countries that are correlated by weights or by volume in USD.
Can we add a nice chart or indicators ?
I can send you the original file.
Thank you for your help.
Have a nice day,
Jaouad
