Truckload efficiency

[jdevalk77]

I do have a challenge;

I'd like to calculate the load efficiency per truckride. I do have a table with ridenumber, parcel/pallet category and quantity and the idea is to calculate the need floorspace known that a pallet uses 1,08 m². To keep it simple we calculated that 16 parcels uses the same floorspace as 1 pallet. So in case of let's say 8 pallets and 14 parcels per ride, the total floorspace would be (8*1,08) + ((14/16)*1,08) = 9,585 m²

I do have multiple rows that contains parcel and pallet data like:

Ridenumber	Parcel_Pallet	Quantity_PCR
52593	Colli	4
52593	Pallet	2
52593	Pallet	1
52593	Pallet	1
52593	Colli	1
52593	Pallet	1
52593	Pallet	1
52593	Colli	6
52593	Pallet	1
52593	Colli	1
52593	Colli	2
52593	Pallet	1

And of course I do have more ridenumbers.
Who could help me? Thanks in advance.

[Greg_Deckler · Accepted solution]

@jdevalk77 If a Colli a parcel then maybe this. PBIX below signature.

Measure = 
    VAR __Pallet = 1.08
    VAR __Parcel = __Pallet / 16
    VAR __Table = 
        ADDCOLUMNS(
            SUMMARIZE('Table', [Ridenumber], 'Table'[Parcel_Pallet], "__Quantity", SUM('Table'[Quantity_PCR])),
            "__M2", IF([Parcel_Pallet] = "Colli", [__Quantity] * __Parcel, [__Quantity] * __Pallet)
        )
    VAR __Result = SUMX( __Table, [__M2] )
RETURN
    __Result

[jdevalk77]

Yes, correct. Sorry, forgot the record translation.

[Greg_Deckler]

@jdevalk77 OK, I edited my original reply with what I believe to be the answer.

[jdevalk77]

This is great, many thanks for your fast repsonse.
Much appreciated.