Forum Discussion
Calculate Direct & Undirect Amount
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 |
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]))
1 Reply
- amitchandak
Super User
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]))