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]))
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
104 | |
58 | |
45 | |
29 | |
24 |
User | Count |
---|---|
133 | |
94 | |
75 | |
44 | |
41 |