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

So, to confirm: the cost of the delivery is represented on each item line, so that the total cost for the delivery is not a SUM of the line costs, but just that one value?

 

You could write a measure like this:

Delivery Cost = MAX( 'TableName'[Delivery Cost] )

 

Then build a table vizualization with your delivery field, and delivery cost measure.