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

    Custom SQL vs Data Blend (Filter problem)

    Bikkem Bergs



      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.