Correlation coefficient
The quick measure calculates the Pearson correlation coefficient between two measures within the category.
NAME:
Correlation coefficient
DESCRIPTION:
Calculate the Pearson correlation...
This is wonderfully useful thanks Daniil
I've been trying to modify your DAX to use in a scenario where the variables to be correlated are pivoted and the categories are contained in an attribute column (example below). Sadly I'm not having much luck, does anyone have any suggestions on how to generate a correlation matrix with this data structure?
| Item | Attribute | Value |
| A | Value X | 2 |
| B | Value X | 3 |
| C | Value X | 5 |
| D | Value X | 7 |
| A | Value Y | 0 |
| B | Value Y | 1 |
| C | Value Y | 1 |
| D | Value Y | 2 |
Statistics only work with numbers. You need to add numerical key columns for your text columns before you can calculate the correlation.