Forum Discussion
Kannan4444
Helper I
2 years agoHow to calculate NET EXPORTS. Plesae help
Guys, i have used below measure to caculate Total exports and Total imports. i want to see Net exports. Same for Loadport as well. DischargePortQuantity = CALCULATE( SUM(BaselineView[KT])...
rajendraongole1
Super User
2 years agoHi Kannan4444 - you have measures to calculate Total Exports and Total Imports. Based on your provided measure for DischargePortQuantity
change the table and column names as per your model .
TotalExports =
CALCULATE(
SUM(BaselineView[KT]),
FILTER(
BaselineView,
BaselineView[DischargePort] IN VALUES(BaselineView[DischargePort])
)
)
For Total Imports, if there is any filters conditions you can apply assuming loadport here
TotalImports =
CALCULATE(
SUM(BaselineView[KT]),
FILTER(
BaselineView,
BaselineView[LoadPort] IN VALUES(BaselineView[LoadPort])
)
)
calculate Net Exports, subtract the Total Imports from the Total Exports
NetExports =[TotalExports] - [TotalImports]
Hope this helps.
if any share some sample data to analyse further.