Forum Discussion
Measure using CALCULATE, FILTER and USERELATIONSHIP
Hello Community - The measure below works but with one important problem: it is referencing the wrong date. In my salesorders table, we normally use "due date" and that is our primary conne...
You need to use CALCULATETABLE and USERELATIONSHIP for both your _CustomersThisMonth and _PriorCustomers variables.
Formula works perfectly! Do you also have a formula for lost clients?
RETURN
COUNTROWS(EXCEPT(_PriorCustomers,_CustomersThisMonth))