Hi,
In my Power BI, I want to do make a measure (Utilization rate per Shipment per StageOfRoute) like below:
Shipment StageOfRoute Product WeightOfProduct MaxWeight UtilizationRateOfContainer
A 1 x 3 10 80%
A 1 y 5 10 80%
A 2 x 3 10 80%
A 2 y 5 10 80%
B 1 x 1 10 70%
B 1 g 2 10 70%
B 1 u 4 10 70%
B 2 x 1 10 70%
B 2 g 2 10 70%
B 2 u 4 10 70%
Total: 75%
As you can also see, I would like the total to be the average utilization rate of the shipments ((1*70 + 1*80)/2 = 75).
The measure that I made now is working on row level, but the total is not correct. The formula that I have now is:
UtilizationRateOfContainer =
CALCULATE (
AVERAGEX(
'Table1';
DIVIDE (
[SumWeightOfProduct (this is a measure that is a sum of the weight of product per shipment stage of route)];
[MaxWeight]
)
);
ALLEXCEPT (
'Tabel 1';
'Tabel 1'[Shipment];
'Tabel 1'[StageOfRoute];
'Tabel 1'[Product]
)
)
But it is not working. Can somebody help me?
Thanks a lot in advance!
