Correlation Coefficient (blank) for a single filter option

[Mirae]

Hey all,

I'm using the Correlation Coefficient quick measure on PowerBI desktop. It responds to filtering by slicer.

On 3/4 filters, I get back a correlation coefficient. Here is an example of one:

On 1 of the filters, I get (Blank).

All options have blank values but the blue one returning (Blank) has the most blank values.

I'm quite new to correlation coefficients so quite lost on this one.

Thanks all!

[v-stephen-msft]

Hi @Mirae ,

Maybe this blog helps you.

It describes what is the Correlation Coefficient and how to visualise in Power BI.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mirae]

Really useful blog but, unfortunately, hasn't shed any light on my issue. Think I must have a unique situation! But love the blog 🙂

[lbendlin]

I find the Quick Measure to be unsatisfactory as it requires a category.  I usually implement the correlation measure manually, and it does not come up with blanks.