Forum Discussion

rqh's avatar
rqh
Frequent Visitor
2 years ago
Solved

Calculation based on Distinct Order ID

Hi everyone šŸ™‚ I want to create a measure to calculate total shipping costs, based on unique Order ID. I am using a star schema, so Order ID is not unique. The main issue is Freight (shipping cos...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    rqh 
    Try  this measure:

    Total Freight = 

SUMX (
    DISTINCT('Orders'[Order ID]),
    CALCULATE ( MAX( 'Orders'[Freight] ) )
)
Fowmy's avatar
Fowmy
Super User
2 years ago

rqh 
Try  this measure:

Total Freight = 

SUMX (
    DISTINCT('Orders'[Order ID]),
    CALCULATE ( MAX( 'Orders'[Freight] ) )
)
  • rqh's avatar
    rqh
    Frequent Visitor
    2 years ago

    Great solution, you're a godsend.