Forum Discussion

Elpida1803's avatar
Elpida1803
Regular Visitor
9 years ago
Solved

Creating Correlation

Hello,I am a statistician and i am using PowerBI for Graphs and Analysis.I want to calculate correlation.I have read other Topics tha suggets R for calculation.My point is that i want to see the numb...
  • Elpida1803's avatar
    Elpida1803
    9 years ago

    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.

Elpida1803's avatar
Elpida1803
Regular Visitor
9 years ago

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.

JaouadZrhibi's avatar
JaouadZrhibi
Helper I
8 years ago

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 ?

 

https://app.powerbi.com/view?r=eyJrIjoiNGNjYWEyMDItMmVhYS00OTVmLTgxM2ItYjFmMjYyODVmMDU5IiwidCI6IjBiOWI3NWE3LTk0MTQtNDg0Ny05NjBkLWRiN2YxNzgyMjk2ZSIsImMiOjl9

 

I can send you the original file.

 

Thank you for your help.

 

Have a nice day,

 

Jaouad