Total Spent per customer regardless of the date slicer

[Andrew_na_lang]

HI Fam,

I urgently need help! 

I need to compute for the total spent of the customer regardless of the date slicer.  I need their running spent. 

please help! 
I have a customer table and orders table that has all the transaction of the customer. 

[johnt75 · Accepted solution]

Assuming that you have a one-to-many relationship from Customers to Orders, and that you have a separate Date table which you are using on slicers and visuals, you can get a total spend with something like

Total Spend = CALCULATE( SUMX( Customers, SUMX( RELATEDTABLE(Orders), Orders[Amount])), REMOVEFILTERS('Date') )