Forum Discussion
Anonymous
5 years agoNot applicable
DAX Correlation
I am trying to create a DAX function to calculate the correlation coefficient for multiple columns. I have a table that has 50 columns with the results of some tests that present different job candidates, I need to calculate the correlation coefficient to see the relationship that exists between the tests, I also need to filter by person and know their correlation. R Graph does not help me since filtering significantly reduces the data, so corrplot does not generate visual
2 Replies
- amitchandak
Super User
Anonymous , refer if these two can help
https://xxlbi.com/blog/pearson-correlation-coefficient-in-dax/
https://community.powerbi.com/t5/Desktop/Calculate-correlation-between-multiple-columns/td-p/1205727
- AnonymousNot applicable
No, the solution you suggest does not solve my problem. Thanks!