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.
Hi
I create 2 tables, one covers operating info, the other with financial info, both are linking with order numbers, I tried to group them by gain or loss. the report is as below
GAIN/LOSS | JOBS | CW_KG | Profit
gain 100 500 500
loss 100 500 -350
total 100 500 -150
The reality is gain job 75, loss job 25, financial profit is correct. How can I fix this? thanks
Hi @REEDZHOU,
Please update your measure job to this one.
jobs = COUNT('MS ODW CONNECT'[UTN])
For more details, please check the pbix as attached.
Regards,
Frank
thanks, Frank
but please note UTN is an unique in MS ODW CONNECT table. UTN is an unique in HAWB table, how can I count them up? thanks
Hi @REEDZHOU,
I am a bit confused about your excepted result, could you please tell we what is the reuslt you want?
Regards,
Frank
Hi Frank
thank you in advacne
HAWB is listed with Orders, which is unique number. MS ODW page is all orders profit, but some orders generated profit in 2 financial periods or more, so they are not unique to listed by Country & UTN. I used order number in HAWB as unnique to linke to Country & UTN in MS ODW report. I want to generate the report from HAWB to list how many job count to get loss /gain or how much chargeable weight to get gain/loss? I broke down to order level. It is ok, all jobs will be listed chargeable & profit. If I want to summary to list them, the chargeable weight & job counts ( these 2 info are sitting HAWB page) are same as below
senario 1
Order | Job Count | Chargeable Weight | Profit
123A 1 523 300
234A 1 250 -100
Senario 2
Gain/loss | Job Count | Chargeable Weight | Profit
Gain 2 773 300
Loss 2 773 -100
The job count & chargeable weight are same in summary.
Hi @REEDZHOU,
Could you please share your sample data and excepted result to me? You can upload your file to dorpbox and share the link here.
Regards,
Frank
Hi please see below I store file in there, thanks
you have just provided the expected result without the source data, please share full required details.
I cannot attached file, please go to below link to view, thanks
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |