Forum Discussion

jackj's avatar
jackj
Helper I
5 years ago
Solved

Customer LTV

I am struggling with this and could use some help in solving the below problem:   I am looking to create a calculated column that totals the cumulative lifetime sales associated with each customer ...
Need Help
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi jackj ,

    If you want the table measure do not affect by the slicer, you can use 'Edit Interaction' to disable the interaction between the table and the slicer.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

jackj , With help from Date table try measure like

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('date'),'date'[date] <=max('date'[date])))

 

or

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,Month)))