Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 delivery. My data looks like this:
Deliver | Item | Delivery Cost |
A | 1 | $1 |
A | 2 | $1 |
A | 3 | $1 |
A | 4 | $1 |
A | 5 | $1 |
B | 6 | $20 |
B | 7 | $20 |
B | 8 | $5 |
C | 9 | $5 |
Solved! Go to Solution.
Hi @TomSinAA ,
Here we go 🙂
Measure = CALCULATE(SUM('Table'[Delivvery cost]),ALLEXCEPT('Table','Table'[Deliver]))
Hi @TomSinAA ,
Here we go 🙂
Measure = CALCULATE(SUM('Table'[Delivvery cost]),ALLEXCEPT('Table','Table'[Deliver]))
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |