1 Reply Latest reply on Oct 25, 2016 5:58 AM by Luciano Vasconcelos

    Custom SQL vs Data Blend (Filter problem)

    Bikkem Bergs

      Hello,

       

      I have a workbook where I need to filter on certain measure and not others. So I duplicated the data source and joined where necessary. The problem is the joins don't pull through properly on the fields which are unfiltered. They sometimes do but I think it's because of the join type restriction.

       

      So I created the joins myself via custom SQL. However, with 1 data source I now cannot filter on certain measures, everything is then affected.

       

      I tried to apply the Fixed and Exclude functions but can't seem to get it to work. Any ideas would be greatly appreciated.

       

      Thank you.