2 Replies Latest reply on Jul 5, 2016 7:49 AM by Rick Fernandez

    Using measures as linked fields

    Rick Fernandez

      Hello,

       

       

      Banging my head trying to find out if it's possible to link a Measure to a Dimension (or maybe even another Measure) in a separate data source?  I have a calculated Measure field that produces a concatenation of 6 different fields, three of which are pointing to a secondary data source, and apparently Tableau automatically converts any fields that are connecting to a secondary data source to aggregate fields, which makes the entire calculated field a Measure.  Problem is that I need to link this field to a separate data source / lookup table in my workbook, and I have found no other way to not reference a secondary source.  Tableau won't let me change the field to a dimension because of this, and I don't know how I can create a workaround to make Tableau read that field as a dimension.  Any thoughts would be appreciated.

       

       

      Thank you,

      Rick