I am struggling with an issue regarding applying a Customer Discount to a Sales Measure.
I have a Line Level FactSales Table that is Related to a Customer Table via the CustomerID.
I have a Sales Measure Called Net Sales = SUM(FactSales[Amount] - SUM(FactCredit[Amount])
I want to apply a Discount which is held in the Customer Table for each Customer to the Net Sales Measure but cannot figure out how I apply it to an already aggregated measure. If it was Line Level I would simply use the Related function to grab the discount but that wouldn’t work in this scenario.
Any help appreciated.