5 Replies Latest reply on Aug 31, 2018 6:50 AM by Shalini Venkatachalapathy

    How to use measures from secondary data source in parameter without using aggregations

    Shalini Venkatachalapathy

      Hi,

      I have a primary data table called "Master List" and secondary data "Region". I have blended the data table using "IP address/IP" as the common field. Now I need a dynamic axis selector for my cross table wherein I used parameters to create it. My parameter contains list of 3 measures, two of them "Category and Sub Cat" comes from the primary table "Master list" and "Geography" comes from the Secondary table "Region". My issue is that I am unable to bring the measure "Geography" in my calculated field (Axis: which is used to make the parameter work) as it is from the secondary data source. I get the following error. How to get my measure "Geography" in the same calculated field so that I can use it in my parameter control.

       

      Message was edited by: Shalini Venkatachalapathy Attached a .twbx file .Previously it was a .twb file