Forum Discussion
Measure Expression Problem: Calculate Average Weight In A Truck By Customer
Hi, I was having a problem on calculating a measure, where I want to know the utilisation percentage of a truck by customer. Take an example from table below, my formula idea is: sum([PRODUCT_GROSS_W...
Here is the sample data to make it easier to understand.
| Customer Name | Item Weight | Vehicle | Vehicle Type | Vehicle Space |
| A | 500 | ABC | SINGLE TIRE | 2000 |
| A | 600 | ABC | SINGLE TIRE | 2000 |
| A | 700 | ABC | SINGLE TIRE | 2000 |
| A | 1000 | CDE | DOUBLE TIRE | 4000 |
| A | 2000 | CDE | DOUBLE TIRE | 4000 |
| B | 300 | FGH | SINGLE TIRE | 2000 |
| B | 400 | FGH | SINGLE TIRE | 2000 |
| B | 500 | FGH | SINGLE TIRE | 2000 |
| B | 750 | IJK | DOUBLE TIRE | 4000 |
| B | 600 | IJK | DOUBLE TIRE | 4000 |
| VEHICLE | WEIGHT | VEHICLE SPACE | TRUCK UTILISATION |
| ABC | 1800 | 2000 | 90% |
| CDE | 3000 | 4000 | 75% |
| FGH | 1200 | 2000 | 60% |
| IJK | 1350 | 4000 | 34% |
| CUSTOMER NAME | AVG TRUCK UTL |
| A | 83% |
| B | 47% |