Forum Discussion

wbhite's avatar
wbhite
Icon for Helper I rankHelper I
7 years ago

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

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!

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      wbhite
      Icon for Helper I rankHelper I
      7 years ago

      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.