DAX to show the Customer_TK in a matrix with lost customer formula
I have used been using some DAX code for new and returning customers from sqlbi, though I am looking for a way to change/update the code to be able to show the Customer_TK in a matrix for Lost Customers.
Three other retention measures working, and when drill down to Customer_TK...
Working correctly. Now I add the Lost Customer measure....
This works great with the date, but....
Not when trying to see the breakdown with Customer_TK
How can I modify this DAX to allow the Lost Customer measure to be filtered by the customer dimension in this matrix.
Here is the DAX...
Lost Customers =
VAR LastDateLost =
VAR CustomersWithLostDate =
"@LostCustomerDate", [Date Lost Customer]
dim_date[date] <= LastDateLost
VAR LostCustomers =
VAR Result =