Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Direct & indirect Country

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 OriginCountry of ImportCommodityMarketValue ($)
BrazilAlgeriaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products17076
BrazilAlgeriaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products33751
ChinaAlgeriaParts 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 Articles855
United 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 Thereof123
United 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 Articles79
ArgentinaArgentinaFrozen Fowls Of The Species Gallus Domesticus, Not Cut In PiecesLive Animals; Animal Products44827
ArgentinaArgentinaNormal wheatVegetable Products2951372
ArgentinaArgentinaGolden Corn, Excluding SeedVegetable Products10161
ArgentinaArgentinaOilcake 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 Substitutes11591
United 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 Articles621
AustraliaAustraliaFresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases)Live Animals; Animal Products393
AustraliaAustraliaFresh Or Chilled Bovine Cuts, With Bone In (Excl. Carcases And 1/2 Carcases)Live Animals; Animal Products931
AustraliaAustraliaFresh Or Chilled Bovine Meat, BonelessLive Animals; Animal Products6536
AustraliaAustraliaFresh Or Chilled Bovine Meat, BonelessLive Animals; Animal Products29399
AustraliaAustraliaFresh Or Chilled Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases)Live Animals; Animal Products58489
AustraliaAustraliaFresh Or Chilled Boneless Cuts Of SheepLive Animals; Animal Products59830
AustraliaAustraliaFrozen Sheep Carcases And Half-Carcases (Excl. Lambs)Live Animals; Animal Products15501
AustraliaAustraliaFrozen Cuts Of Sheep, With Bone In (Excl. Carcases And Half-Carcases)Live Animals; Animal Products284520
AustraliaAustraliaMeat Of Sheep (Excluding Minced Meat), Boneless, Frozen, Fit For Human ConsumptionLive Animals; Animal Products59215
AustraliaAustraliaMilk & 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 Products25624
AustraliaAustraliaFresh Cheese "Unripened Or Uncured Cheese", Incl. Whey Cheese, And CurdLive Animals; Animal Products3811
AustraliaAustraliaProcessed Cheese, Not Grated Or PowderedLive Animals; Animal Products33259
AustraliaAustraliaNatural honey.Live Animals; Animal Products106740
AustraliaAustraliaFresh Or Chilled Carrots And TurnipsVegetable Products7414
AustraliaAustraliaFresh GrapesVegetable Products1142
AustraliaAustraliaFresh WatermelonsVegetable Products462
AustraliaAustraliaFresh ApricotsVegetable Products2394
2 REPLIES 2
rautaniket0077
Resolver I
Resolver I

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.

tamerj1
Super User
Super User

Hi @Anonymous 
Can you please provide sample of the expected results?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.