Correlation coefficient "Blank" undefined

Question

I am new to Power BI.&nbsp; I have a very simple table of 43 rows.&nbsp; Excerpt below.&nbsp; There are no blanks or zeros in the last two columns.&nbsp;&nbsp;I was able to get a scatter plot and trend line.&nbsp; But when using the Quick Measure for the correlation coefficient, it returns "(Blank)".&nbsp;What am I doing wrong?Excerpt of table&nbsp;&nbsp;Results in this DAX&nbsp;Count of Direct Hire Jobs and Count of Direct Hire Revenue correlation for Direct Hire Revenue = VAR __CORRELATION_TABLE = VALUES('Sheet2'[Direct Hire Revenue])VAR __COUNT =&nbsp; &nbsp; COUNTX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTA('Sheet2'[Direct Hire Jobs])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * COUNTA('Sheet2'[Direct Hire Revenue])&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )VAR __SUM_X =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTA('Sheet2'[Direct Hire Jobs]))&nbsp; &nbsp; )VAR __SUM_Y =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTA('Sheet2'[Direct Hire Revenue]))&nbsp; &nbsp; )VAR __SUM_XY =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTA('Sheet2'[Direct Hire Jobs])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * COUNTA('Sheet2'[Direct Hire Revenue]) * 1.&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )VAR __SUM_X2 =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTA('Sheet2'[Direct Hire Jobs]) ^ 2)&nbsp; &nbsp; )VAR __SUM_Y2 =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(__CORRELATION_TABLE),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTA('Sheet2'[Direct Hire Revenue]) ^ 2)&nbsp; &nbsp; )RETURN&nbsp; &nbsp; DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; __COUNT * __SUM_XY - __SUM_X * __SUM_Y * 1.,&nbsp; &nbsp; &nbsp; &nbsp; SQRT(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (__COUNT * __SUM_X2 - __SUM_X ^ 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * (__COUNT * __SUM_Y2 - __SUM_Y ^ 2)&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )&nbsp;Sadly, this is the response.&nbsp;&nbsp;

lbendlin · Answer

which correlation are you trying to find?
&nbsp;
Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Correlation coefficient "Blank" undefined

1 Reply

Related content

Quick Measure Correlation Coefficient

Remove "(BLANK)" values

Pearson Coefficient correlation for Performance trend

Category in Correlation Coefficient

Correlation Coefficient DAX Measure Error