Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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]))
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
20 | |
19 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
24 | |
23 | |
21 |