Forum Discussion

TomSinAA's avatar
TomSinAA
Icon for Helper IV rankHelper IV
6 years ago
Solved

Select Distinct

I have a table with deliveries and items in each delivery.  I want to get the cost for each delivery but each item has the cost for the delivery.  How do I create a measure to get the cost for a deli...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi TomSinAA ,

     

    Here we go 🙂

    Measure = CALCULATE(SUM('Table'[Delivvery cost]),ALLEXCEPT('Table','Table'[Deliver]))

     

     

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
6 years ago