A **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**:

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:

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