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_WEIGHT]) divided by the weight of [TRUCK_REGISTRATION_NUMBER], where the weight can be determined by from [typekendaraan]. Any help is appreciated, thank you.
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Here 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%
