Ignore filter

[AOD]

Hi All, 

I have posting preiod on my selection screen of type select single .

and below is table 

Posting period	Amnt
001	10
002	20
003	30
004	40
005	50
006	60
007	70
008	80
009	90

I have 'Actuals to date' to be calculated as cumulated as per selected value on filter 

eg : if 003 is selected then Actual to date should be calculated as 60 .

This is working fine as per below formula. 

Actual to date = calculate(SUM('With Period'[Amnt in FM area crcy]),'With Period'[Posting period.Posting period Level 01] <= SELECTEDVALUE('With Period'[Posting period.Posting period Level 01]) )

however when I pull Posting period in my chart on same page it only displayes posting period as 003 with total amount as 60 rather I am looking for as below when filter is selected as 003

Posting period	Amnt
001	10
002	20
003	30

 if filter is 004 and table as posting period then it should be as below

Posting period	Amnt
001	10
002	20
003	30
004	40

if filter is 004 and posting period is not added inthe table then value should be 

100 in table. 

Kindly help. 

Thanks.

[amitchandak · Accepted solution]

@AOD , Create an independent table of Posting period

Priod = distinct(Table[Posting period])

Use that in slicer

In visual table Posting period from Table and this measure 

Measure = calculate(Sum(Table[Amnt]), filter(Table, Table[Posting period] <= selectedvalues(period[Posting period]) ) )