Hello Experts,
I want to calculate 2 measures for Direct & undirect Amount using data attached to show this value in table chart to each country whats the direct and indirect;
- Direct: Country of Origin and Country of Import are the same,
- Indirect: Country of Origin is NOT equal Country of Import.
For Example using UAE Country: - Direct: Country of Origin & Country of Import = UAE
-Indirect: Country of Origin = UAE, Country of Import <> UAE
UAE is an example, but I want to show all country of imports in a table chart to see the direct and indirect for each country.
Thanls in Advamced.
Country of Origin | Country of Import | Commodity | Point of Entry | Amount |
China | China | Multiple Loudspeakers | Sarfayt Land Border | 34 |
China | UAE | Natural Gas, Liquefied | SOHAR (SEA PORT) | 3445 |
UAE | UAE | Ball Bearings | Al Wajajah Land Border | 5676 |
China | China | Electric Doorbells | Customs HQ | 6768 |
China | UAE | Tableware Or Kitchenware | HAFEET (BORDER POST) | 342 |
UAE | KSA | Parts Of Gas Turbines, N.E.S. | Sarfayt Land Border | 132 |
China | UAE | Multiple Loudspeakers | KHATMAT MILAHA (BORDER POST) | 323 |
Turkey | UAE | Skulcaps (Taqias) | Al Darah | 234 |
China | Russia | Audio-Frequency Electric Amplifiers | Al Wajajah Land Border | 4545 |
China | India | Dress Patterns | SUWEIQ (SEA PORT) | 76 |
Turkey | Turkey | Inductors, N.E.S | AL DUQM (SEA PORT) | 545 |
KSA | Oman | Motors Of An Output <= 37,5 W | SARFAIT (BORDER POST) | 386 |
KSA | KSA | Multiple Loudspeakers | CENTRAL POST OFFICE | 217 |
KSA | Japan | Electric Doorbells | Salalah International Airport Passenger | 463 |
KSA | KSA | Natural Gas, Liquefied | DIBA PORT (BORDER POST) | 288 |
KSA | India | Fuel oils For ships | Al Darah | 360 |
USA | USA | Frozen Cuttle fish and squid | DIRECTORATE GENERA | 128 |
USA | Brazil | Dress Patterns | Sarfayt Land Border | 190 |
USA | Canada | Audio-Frequency Electric Amplifiers | ARKAN SOHAR LOGISTICS LLC NORTH | 354 |
USA | USA | Sweet Biscuits | HAFEET (BORDER POST) | 300 |
USA | USA | Hair Lacquers | ARKAN SOHAR LOGISTICS LLC NORTH | 142 |
USA | Egypt | Household Ware Of Zinc | DIBA PORT (BORDER POST) | 188 |
USA | Iraq | Sweet Biscuits | Sarfayt Land Border | 149 |
Solved! Go to Solution.
@Anonymous , You can try two measures like
Direct =Calculate(Sum(Table[Amount]), filter(Table, Table[Country of Origin] = Table[Country of Import]))
In Direct = Calculate(Sum(Table[Amount]), filter(Table, Table[Country of Origin] <> Table[Country of Import]))
@Anonymous , You can try two measures like
Direct =Calculate(Sum(Table[Amount]), filter(Table, Table[Country of Origin] = Table[Country of Import]))
In Direct = Calculate(Sum(Table[Amount]), filter(Table, Table[Country of Origin] <> Table[Country of Import]))