How to Calculate a Correlation Coefficient in Power BI


correlation coefficient is a measure of the linear association between two variables.

It can take on a value between -1 and 1 where:

  • -1 indicates a perfectly negative linear correlation between two variables
  • 0 indicates no linear correlation between two variables
  • 1 indicates a perfectly positive linear correlation between two variables

The easiest way to calculate a correlation coefficient between two columns in Power BI is to use the Quick Measure function.

The following example shows how to do so in practice.

Example: How to Calculate a Correlation Coefficient in Power BI

Suppose we have the following table named my_data in Power BI that contains information about total ad spend and total revenue for various grocery stores:

Suppose that we would like to calculate the correlation coefficient between Ad Spend and Revenue.

To do so, click the Table Tools tab and then click the Quick measure icon:

In the Quick measure panel that appears on the right side of the screen, click the dropdown arrow next to Select a calculation and then scroll down and click Correlation coefficient:

Next, choose Store for the Category, Ad Spend for the Measure X, and Revenue for the Measure Y.

Then click Add:

Power BI correlation coefficient

This will automatically generate the DAX code necessary to calculate the correlation coefficient between Ad Spend and Revenue:

To view the correlation coefficient, you can switch to the Report View and add a card visualization that displays the correlation coefficient:

Power BI display correlation coefficient between two fields

We can see that the correlation coefficient between Ad Spend and Revenue is 0.56.

Related: What is Considered to Be a “Strong” Correlation?

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Calculate Average in Power BI
How to Calculate Standard Deviation in Power BI
How to Calculate Max in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *