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