8 Replies Latest reply: Apr 9, 2018 3:57 PM by Sunny Talwar RSS

    Ignore all selections in field selected

    Ugur Arslan

      Dear all,

       

      I have a sheet which with two KPI's, which are showing 1 KPI for the number by month and the other one KPI shows me the total ytd.

       

      For the first KPI I am using the following expression:

      =sum([Fruit Type]={'apple'}>}[AR USD]), the result is triggered by the filter selection YEAR Month, so if you select 201803 you get 10 etc.

       

      For the second one I am using the following:

      Sum({<[Year Month]=1{">=$(=YearStart(today()))<=$(=MonthEnd(AddMonths(today(),-1)))"},[Fruit Type]={'apple'}>} [AR USD]), this number needs to stay 40 USD apples sold this year. Doesn't matter which selection you do in YEAR Month.

       

      But what happens now is if I select 201803 in Year month, the first KPI Month changes correctly, but YTD also changes in to 10.

       

      So my question is:

       

      How can I make this field a static field and it shows me all AR on apples despite the year month selected:

       

      Sum({<[Year Month]=1{">=$(=YearStart(today()))<=$(=MonthEnd(AddMonths(today(),-1)))"},[Fruit Type]={'apple'}>} [AR USD])

       

      Thanks

       

      Ugur