Forum Discussion
Solved
Average LTV Measure
Hi all, I'm trying to create a measure that returns the average LTV for all customers in table. The table has individual product purchases for rows, so I want to add up all the instances of a pr...
RyanNewportJP First create a measure for Total Sales per Customer
TotalSalesPerCustomer =
SUMX(
VALUES(Table[CustomerID]),
CALCULATE(SUM(Table[Sales]))
)Then create a measure for Average LTV
AverageLTV =
AVERAGEX(
VALUES(Table[CustomerID]),
[TotalSalesPerCustomer]
)
RyanNewportJP First create a measure for Total Sales per Customer
TotalSalesPerCustomer =
SUMX(
VALUES(Table[CustomerID]),
CALCULATE(SUM(Table[Sales]))
)
Then create a measure for Average LTV
AverageLTV =
AVERAGEX(
VALUES(Table[CustomerID]),
[TotalSalesPerCustomer]
)
Thank you very much! This worked!
Can I ask why it works?
