Forum Discussion

TomSinAA's avatar
TomSinAA
Helper 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]))

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi TomSinAA ,

 

Here we go 🙂

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