Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |