3 Replies Latest reply: Aug 20, 2015 2:52 AM by David Brandstädter RSS

    Using set-analysis to filter dimension in line chart

    David Brandstädter

      Hi,

       

      I'm trying to filter the dimension of a line chart in such a way that only specific values are shown:

       

      if([Date] < Max({$<[F_FCI_Flag]={1}>}[Date]), MonthName([Date]))


      If I put only the set-analysis statement in e.g. a KPI, it yields a value.

      However, for the line chart I receive an "invalid dimension" error.

       

      Date is a shared dimension among different fact tables which is why I introduced the "Flag" in order to identify a given facts table.

       

      Can anyone help?

       

      Thanks!

       

      David