Forum Discussion

Kannan4444's avatar
Kannan4444
Helper I
2 years ago

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

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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.

  • Kannan4444's avatar
    Kannan4444
    Helper I
    2 years ago

    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 😞