Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, I am having trouble with my dax calculation to effectivelly allocate rebate dollars based on share of net spend per product catagory (MERGED)
I have calculated each custoemrs sales share correctly using the formula: Calculate(total sales) / calculate(total sales),all(table1,customername)
But I now want to take that share and multiply the total rebate amount per product segment for each customer to allocate rebate amount for each customer but I am not getting correct answers. Please see below screenshot to see my calculations.
For example, the highlighted customer should have $33,478 total rebate amount and not $2921 as their sales share was 50.33%. Any help would be appreciated
@cdawidow , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |