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?