This is a great use case for Data Blending in Tableau. Consider making two separate data sources that are each connected to a single table, and blend them together in your visualization. You can control the link level of detail by clicking the link icon in the Data window. Since Tableau will only join the two result sets after aggregating from each data source, you won't have the measure double-counting problem that you experience with a native join.
I also have the same issue at my work.
I tried using the tables as different data sources and blend the data for my use to avoid the duplication of data
but the filters will not work across the data sources which is causing trouble.
I have multiple worksheets from the data sources that I have and I want to use a filter that filters across all the sheets.
And that filter cannot work out of that data source which is a drawback.
Is there a way to fix this.
Thanks & Regards,
Same problem for me!
Any luck Raja?