3 Replies Latest reply on Oct 11, 2018 7:47 AM by Jonathan Drummey

    Double Counting After Join

    Benjamin Cole

      Hi Ya'll,

       

      Is there a slick way around fixing my measures post a join? 

       

      Table A = store_location

      Table B = products

       

      Lets say I join store_location to products on store_id

       

      A measure  --> #_of_employees is from the store_location table and because of the join it has now been multiplied by every store_id.

       

      After this kerfuffle I created a calculated field to correct the measure.

       

           NEW_#_of_employees = sum(#_of_employees) / Count(storeID)

      My fix is working, but it seems sloppy.  Any thoughts out there?

       

      Thanks,

      Ben

      StoreID