Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings developers, do point me to the right direction if this has been posted somewhere because I found none. I have a simple problem but does not seems to have simple solution. Basically I need to calculate the order fee per unique order, transactional data is in Sales Table, and fee information is in Charges table.
I have tried various method including blocking context transition by using variable in the SUMX on Charges table, either the row level is correct but total is incorrect or vice versa. These two are separate table from the source. Appreciate if anyone could lend a helping hand for a frustated analyst. I have attached a link to the pbix file.
Expected result:
Platform | Orders | Order Fee |
DEF | 2 | 7 |
XYZ | 1 | 5 |
Total | 3 | 12 |
@smko , You can create a new columns in Sales
Hi @amitchandak, thanks for helping. However the sales table has lineitem, the logic you wrote will return the charges to each of the lineitem, multiplying OrderID will equal to inflated value. Is there any alternative solution for this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |