For more details regarding the functions that were used in this recipe, please refer to the following links:
- Daniil's correlation coefficient: https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/m-p/196274
- Pearson's correlation coefficient: https://en.wikipedia.org/wiki/Pearson_correlation_coefficient
- SELECTCOLUMNS: https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
- FILTER: https://docs.microsoft.com/en-us/dax/filter-function-dax
- ADDCOLUMNS: https://docs.microsoft.com/en-us/dax/addcolumns-function-dax
- ALL: https://docs.microsoft.com/en-us/dax/all-function-dax
- RELATEDTABLE: https://docs.microsoft.com/en-us/dax/relatedtable-function-dax
- SUMX: https://docs.microsoft.com/en-us/dax/sumx-function-dax
- NOT: https://docs.microsoft.com/en-us/dax/not-function-dax
- ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax
- BLANK: https://docs.microsoft.com/en-us/dax/blank-function-dax
- AVERAGEX: https://docs.microsoft.com/en-us/dax/averagex-function-dax
- SWITCH: https://docs.microsoft.com/en-us/dax/switch-function-dax
- COUNTROWS: https://docs.microsoft.com/en-us/dax/countrows-function-dax
- DIVIDE: https://docs.microsoft.com/en-us/dax/divide-function-dax
- SQRT: https://docs.microsoft.com/en-us/dax/sqrt-function-dax
- KEEPFILTERS: https://docs.microsoft.com/en-us/dax/keepfilters-function-dax
- CALCULATE: https://docs.microsoft.com/en-us/dax/calculate-function-dax
- MAX: https://docs.microsoft.com/en-us/dax/max-function-dax
- MAXX: https://docs.microsoft.com/en-us/dax/maxx-function-dax