Forum Discussion

AOD's avatar
AOD
Helper III
4 years ago
Solved

Ignore filter

Hi All, 

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

 

and below is table 
Posting period Amnt
00110
00220
00330
00440
00550
00660
00770
00880
00990

 

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
00110
00220
00330

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

Posting period Amnt
00110
00220
00330
00440

 

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

100 in table. 

 

Kindly help. 

Thanks.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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]) ) )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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]) ) )