Table Filtered but want a column to ignore table filter and give summed value for all

[KarenFingerhut]

Hi there

I have a table returning customer numbers, with payments values in a column. The table is filtered to the relative week, so value for that week showing in the column called Relative Week = 0. What I also want is to add a column that gives the overall total,all weeks summed for that customer against every week in the dataset. So for example

Tenant	Relative  week = 0	All weeks Summed Up
1	25	500
2	10	200
3	15	60
4	100	1000

I just cant get my DAX to work. 

I'd be very grateful if somoene could help please

Many thanks

Karen

[KarenFingerhut · Accepted solution]

I have sorted it by using IGNOREFILTERS 🙂

CALCULATE(SUM(Value]),REMOVEFILTERS(table[relative_week]))