Forum Discussion
Solved
Revenue per customer
Hi, I'm trying to write a DAX measure where it calculates the average revenue per customer, but I'm getting nowhere :-) I have 3 tables: - date table - sales table - visitors and buying custom...
lekkerbek Depends what filters you are going to use. Correct me if is a simple approach but average can calculated if devide revenue by customers.
This is mostly if you try to filter by dates.
Avg Revenue = VAR Customers = SUM(Visitors[Buyers]) VAR Revenue = SUM ( Sales[Revenue]) Return DIVIDE ( Revenue ; customers )
If you need to filter by other columns like Region that needs another approach
lekkerbek Depends what filters you are going to use. Correct me if is a simple approach but average can calculated if devide revenue by customers.
This is mostly if you try to filter by dates.
Avg Revenue = VAR Customers = SUM(Visitors[Buyers]) VAR Revenue = SUM ( Sales[Revenue]) Return DIVIDE ( Revenue ; customers )
If you need to filter by other columns like Region that needs another approach
Thanks that worked excellent!