Total Usable Cube Measure Help

[Anonymous]

Hello,

I am trying to build a key measure called Total Usable Cube and need help. I need the measure to be calculated by taking the 'Truck Specs'[Usable Truck Cube (ft)] field and multiplying it by the number of distinct 'Tote Info'[Ship Date]. I have created a key measure called # of Ship Dates for the number of distinct ship dates. The current results of my Total Usable Cube measure are much larger than I expect the results to be. Please see the screenshot below.

Additional note: After I get the Total Usable Cube to work I plan to obtain the Usable Cube Utilization % by doing Total Cube/Total Usable Cube.

Total Usable Cube = SUM('Truck Specs'[Usable Truck Cube (ft)])*[# of Ship Dates]

File location: https://1drv.ms/u/s!AiFttrDOn_FqgRcfly65h1jvKaXx?e=p0L7TB

[Anonymous · Accepted solution]

I figured out the solution.

Total Usable Cube = SUMX('Truck Specs', 'Truck Specs'[Usable Truck Cube (ft)]*[# of Ship Dates])

[v-piga-msft]

Hi @Anonymous ,

From your sample pbix, I have not found any problem based on your formula.

What is your expected output for Total Usable Cube? If it is convenient, could you show the desired result so that we could helpfurther on it?

In addition, please note do not upload your sensitive data here.

Best Regards,

Cherry

[Anonymous]

@v-piga-msft Cherry,

Example of expected result on the first row of the image I attached.

Expected Result: Total Usable Cube = Usable Truck Cube (872)  x # of Ship Dates (93) = 81,096

Current Result: 4,135,896