Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Customer Retention Dax Measure: Memory Problems

Hello. I was trying to replicate the radacad dax solution for new, lost, and returning customers.

Radacad Link: https://radacad.com/customer-retention-in-power-bi-dax-measures

My data file is about 1.5gb. Stored Locally. Unfortunately I'm on an old work computer with only 8gb of ram. I can only use local storage or I'll have to figure out how to use work servers(but that would cause a decent delay so prefer not to if possible). My goal is to have all 3 measures be dynamic so I can enter a period of time and then see how new, lost, and returning customer change. I did the new customer measure prior to seeing the Radacad one so its different but works. Unfortunately I run into memory problems for the lost and returning customer measures using the Radcad solution both fixed and dynamic time periods. Does anyone have any ideas on how to fix the issue. Thank you.

 

I was able to use a different measure for new customers:

new customer = 
VAR Current_Customers = Values(Invoice[Customer ID]
VAR prior_customers = CALCULATETABLE(VALUES(Invoice[Customer ID]),
                        Filter(ALL(Invoice),
                        Invoice[Invoice Paid Date] > Min(Invoice[Invoice Paid Date]) - 365 &&
 Invoice[Invoice Paid Date] < Min (Invoice[Invoice Paid Date])))
Return
Countrows(
    except(Current_customer, prior_customers))

 

2 Replies