How to calculate NET EXPORTS. Plesae help

[Kannan4444]

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]),

    FILTER(

        BaselineView,

        BaselineView[DischargePort] IN VALUES(BaselineView[DischargePort])

    )

)

I have Load port and Discharge port in a separte column. 2 separate slicers for Load port and Discharge port, with Edit interaction have made sure load port slicer changes doesnt impact the discharge port chat.

Now i need to calculate NET exports. Please help 😞

[Kannan4444]

I already have the measure created like the one you mentioned for export and import, but still am not able to see the NET exports, its BLANK 😞

[rajendraongole1]

Hi @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.