Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Guys, i have used below measure to caculate Total exports and Total imports. i want to see Net exports.
Same for Loadport as well.
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 😞
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.
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |