Direct & indirect Country

Question

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.&nbsp;&nbsp;2- Also, can know what its the direct &amp; indirect commodity based on step 1?&nbsp;Attached is data to provide the solution,&nbsp;Thanks in Advanced&nbsp;Country of OriginCountry of ImportCommodityMarketValue ($)BrazilAlgeriaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products17076BrazilAlgeriaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products33751ChinaAlgeriaParts 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 Articles855United States of AmericaAngolaOther articles of plastics and articles of other materials of headings Nos. 39.01 to 39.14Plastics And Articles Thereof; Rubber And Articles Thereof123United States of AmericaAzerbaijanBalls, 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 Articles79ArgentinaArgentinaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products44827ArgentinaArgentinaNormal wheatVegetable Products2951372ArgentinaArgentinaGolden Corn, Excluding SeedVegetable Products10161ArgentinaArgentinaOilcake And Other Solid Residues, Whether Or Not Ground Or In The Form Of Pellets, Resulting From The Extraction Of Cotton Seeds &nbsp;Prepared Foodstuffs; Beverages, Spirits And Vinegar; Tobacco And Manufactured Tobacco Substitutes11591United States of AmericaArgentinaParts 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 Articles621AustraliaAustraliaFresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases)Live Animals; Animal Products393AustraliaAustraliaFresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases)Live Animals; Animal Products931AustraliaAustraliaFresh Or Chilled Bovine Meat, BonelessLive Animals; Animal Products6536AustraliaAustraliaFresh Or Chilled Bovine Meat, BonelessLive Animals; Animal Products29399AustraliaAustraliaFresh Or Chilled Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases)Live Animals; Animal Products58489AustraliaAustraliaFresh Or Chilled Boneless Cuts Of SheepLive Animals; Animal Products59830AustraliaAustraliaFrozen Sheep Carcases And Half-Carcases (Excl. Lambs)Live Animals; Animal Products15501AustraliaAustraliaFrozen Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases)Live Animals; Animal Products284520AustraliaAustraliaMeat Of Sheep (Excluding Minced Meat), Boneless, Frozen, Fit For Human ConsumptionLive Animals; Animal Products59215AustraliaAustraliaMilk &amp; 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 Products25624AustraliaAustraliaFresh Cheese "Unripened Or Uncured Cheese", Incl. Whey Cheese, And CurdLive Animals; Animal Products3811AustraliaAustraliaProcessed Cheese, Not Grated Or PowderedLive Animals; Animal Products33259AustraliaAustraliaNatural honey.Live Animals; Animal Products106740AustraliaAustraliaFresh Or Chilled Carrots And TurnipsVegetable Products7414AustraliaAustraliaFresh GrapesVegetable Products1142AustraliaAustraliaFresh WatermelonsVegetable Products462AustraliaAustraliaFresh ApricotsVegetable Products2394

tamerj1 · Answer

Hi&nbsp;Anonymous&nbsp;Can you please provide sample of the expected results?

rautaniket0077 · Answer

Try using this below measure in your table.

Measure =

SWITCH(

TRUE(),

MAX(Sheet1[Country of Import]) = MAX(Sheet1[Country of Origin]),"Direct Country",

MAX(Sheet1[Country of Import]) <> MAX(Sheet1[Country of Origin]),"Indirect Country"

)

Mark my answer as solution if it solves your issue.

Forum Discussion

Direct & indirect Country

2 Replies

Related content

Direct Reports Hierarchy Slicer Returning Indirect Reportees Instead of Only Direct Reportees

Direct and Indirect Report

Direct - Indirect Report Help

Country Code to Country Name

Direct & indirect Commodity

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