2 Replies Latest reply on Oct 10, 2016 9:07 AM by Diogo Braga

    Global Filter SQL Server

    Diogo Braga

      I have 3 tables in one database that I will use as a source for the dashboard. The problem I am having with joining or blending is that values get duplicated and I can't average them, it needs to be a sum (is there a way around this?). Unless I am missing something, the solution I am thinking is to add New Data Source 3 times for each of the tables so they show in different canvas, but then I would like them to be controlled by one global filter. Is this even possible? Please help me understand my options! Thank you!