I am using a Sumx to get a total in for each merchant. The issue is when I add the the measure using Sumx I get in the total for everything not the total for the merchant. I believe it is a model issue becuase the item that I am summing is on the project table and has to join in the merchant.
Two table that I am using is
Product UPS which contains that amount that I am Summing which is AsortProbCount
And the Merchant Name is coming from the TrackerNoDups.
Here is the model:
Thanks for your help!