Forum Discussion
Error in Correlation Coefficient
Hi v_mark yes, you're correct in your theory. The error looks to be driven by blanks / 0s and is causing that. If you are able to remove blanks / 0s either in the raw data, using Power Query, or other dax methods, I'd recommend doing this.
Also, I definitely recommend taking a look at this link that is likely to assist as well: https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/pearson-correlation-coefficient/
And one other great little resource: https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/m-p/196274
Hope this helps mate.
Theo
Hi v_mark yes, you're correct in your theory. The error looks to be driven by blanks / 0s and is causing that. If you are able to remove blanks / 0s either in the raw data, using Power Query, or other dax methods, I'd recommend doing this.
Also, I definitely recommend taking a look at this link that is likely to assist as well: https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/pearson-correlation-coefficient/
And one other great little resource: https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/m-p/196274
Hope this helps mate.
Theo