Need help understanding how this calculation is working and how to get my desired result

[wbhite]

Hello all,

I'm scratching my head trying to figure this one out.  Referring to the image below, you'll see that I have sales listed for a single account for 2 months.  We are trying to calculate the amount of rebates that get applied to those sales in each month based on 15% of the sales, however, PBI is doubling the percentage because (I assume) there are 2 records.

For example, in the first line (period 8), the REBATES amount is being calculated at 30% (15% x 2 records) instead of just 15%.  The same is true for the second line.  Any thoughts or suggestions?  Thanks!

[v-yuta-msft]

Hi wbhite,

Is REBATES% a calculate column or a measure? Could you show the DAX formula of REBATES% so that further analysis can be done?

Regards,

Jimmy Tao

[wbhite]

Sorry for the late reply.  [REBATES %] is a data column from the source. [REBATES] is a measure:

REBATES = SUM(tblSalesOrderHistory_From_F55DWNSLSM[EXTENDED PRICE])*SUM(tblOtherCustomerCosts[REBATES %])

[EXTENDED PRICE] (Sales $) comes from one data source and [REBATES %] from another, both related by customer account # with a "middle man" table since I don't have many-to-many enabled.

Thanks.