I have two workbooks that are joined on multiple dimensions. There is a measure in the secondary workbook that is needed to fix dimensions in the primary data source. The primary data source cannot be changed. Is there a way to work around tableau stopping fixing on a secondary data source.
The error I am receiving is:
'all fields in a level of detail expression must come from the same data source'
Error is obvious, in data blending there are few limitations like you can't use LOD and table calculations with secondary source.
Try to use Custom SQL join instead of data blending to join both the sources. Kindly share some mock up data in crosstab format.