DAX Correlation

[Anonymous]

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

[Anonymous]

No, the solution you suggest does not solve my problem. Thanks!

[amitchandak]

@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