Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper 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 001 10 002 20 003 30 004 40 005 50 006 60 ...
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]) ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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]) ) )