Microsoft Power BI Cookbook

Analyze the clusters

1. Create three additional measures to help describe the clusters created and use a simple table to visualize them.

Average Customer Sales = AVERAGEX(VALUES(Customer[Customer Alternate Key]),[Internet Net Sales])Average Customer Orders = AVERAGEX(VALUES(Customer[Customer Alternate Key]),[Internet Sales Orders])Average Days Since Last Purchase = AVERAGEX(VALUES(Customer[Customer Alternate Key]),[Days Since Last Purchase])

• AVERAGEX() is used to iterate over the unique customer keys provided by VALUES() to compute the customer-specific value (sales, orders, and days since purchase) and then return the average of the customers from each cluster:

Average Customer Measures used with the Europe Customers (RFM) Cluster

Per ...