Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |