The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Expert,
1- How to calculate direct country (import country = origin country) and calculate indirect country (import country is not equal to origin country), to put them in coulmn chart.
2- Also, can know what its the direct & indirect commodity based on step 1?
Attached is data to provide the solution,
Thanks in Advanced
Country of Origin | Country of Import | Commodity | Market | Value ($) |
Brazil | Algeria | Frozen Fowls Of The Species Gallus Domesticus, Not Cut In Pieces | Live Animals; Animal Products | 17076 |
Brazil | Algeria | Frozen Fowls Of The Species Gallus Domesticus, Not Cut In Pieces | Live Animals; Animal Products | 33751 |
China | Algeria | Parts Of Non-Electrical Engines And Motors, N.E.S. | Machinery And Mechanical Appliances; Electrical Equipment; Parts Thereof;Sound Recorders And Reproducers, Television Image And Sound Recorders And Reproducers, And Parts And Accessories Of Such Articles | 855 |
United States of America | Angola | Other articles of plastics and articles of other materials of headings Nos. 39.01 to 39.14 | Plastics And Articles Thereof; Rubber And Articles Thereof | 123 |
United States of America | Azerbaijan | Balls, Needles And Rollers For Bearings (Excl. Steel Balls Of Heading 7326) | Machinery And Mechanical Appliances; Electrical Equipment; Parts Thereof;Sound Recorders And Reproducers, Television Image And Sound Recorders And Reproducers, And Parts And Accessories Of Such Articles | 79 |
Argentina | Argentina | Frozen Fowls Of The Species Gallus Domesticus, Not Cut In Pieces | Live Animals; Animal Products | 44827 |
Argentina | Argentina | Normal wheat | Vegetable Products | 2951372 |
Argentina | Argentina | Golden Corn, Excluding Seed | Vegetable Products | 10161 |
Argentina | Argentina | Oilcake And Other Solid Residues, Whether Or Not Ground Or In The Form Of Pellets, Resulting From The Extraction Of Cotton Seeds | Prepared Foodstuffs; Beverages, Spirits And Vinegar; Tobacco And Manufactured Tobacco Substitutes | 11591 |
United States of America | Argentina | Parts Of Valves And Similar Articles For Pipes, Boiler Shells, Tanks, Vats Or The Like, N.E.S. | Machinery And Mechanical Appliances; Electrical Equipment; Parts Thereof;Sound Recorders And Reproducers, Television Image And Sound Recorders And Reproducers, And Parts And Accessories Of Such Articles | 621 |
Australia | Australia | Fresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases) | Live Animals; Animal Products | 393 |
Australia | Australia | Fresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases) | Live Animals; Animal Products | 931 |
Australia | Australia | Fresh Or Chilled Bovine Meat, Boneless | Live Animals; Animal Products | 6536 |
Australia | Australia | Fresh Or Chilled Bovine Meat, Boneless | Live Animals; Animal Products | 29399 |
Australia | Australia | Fresh Or Chilled Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases) | Live Animals; Animal Products | 58489 |
Australia | Australia | Fresh Or Chilled Boneless Cuts Of Sheep | Live Animals; Animal Products | 59830 |
Australia | Australia | Frozen Sheep Carcases And Half-Carcases (Excl. Lambs) | Live Animals; Animal Products | 15501 |
Australia | Australia | Frozen Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases) | Live Animals; Animal Products | 284520 |
Australia | Australia | Meat Of Sheep (Excluding Minced Meat), Boneless, Frozen, Fit For Human Consumption | Live Animals; Animal Products | 59215 |
Australia | Australia | Milk & Cream, For Industrial Purposes, Concentrated Not Containing Added Sugar Or Other Sweetening Matter, In Powder, Granules Or Other Solid Forms, Of A Fat Content, By Weight, Exceeding 1.5 % | Live Animals; Animal Products | 25624 |
Australia | Australia | Fresh Cheese "Unripened Or Uncured Cheese", Incl. Whey Cheese, And Curd | Live Animals; Animal Products | 3811 |
Australia | Australia | Processed Cheese, Not Grated Or Powdered | Live Animals; Animal Products | 33259 |
Australia | Australia | Natural honey. | Live Animals; Animal Products | 106740 |
Australia | Australia | Fresh Or Chilled Carrots And Turnips | Vegetable Products | 7414 |
Australia | Australia | Fresh Grapes | Vegetable Products | 1142 |
Australia | Australia | Fresh Watermelons | Vegetable Products | 462 |
Australia | Australia | Fresh Apricots | Vegetable Products | 2394 |
Try using this below measure in your table.
Hi @Anonymous
Can you please provide sample of the expected results?
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |