The objective of this example is to create a DAX measure which executes the the Pearson correlation coefficient formula.
- A fact table is available at the grain of product category by month with both marketing expense and sales amount
- The values in the active filter context for the Marketing Amt and Sales columns will provide the X and Y arrays
- Create the correlation numerator measure
Correl Numerator ...