Cannot convert value of type text to type true false

[Anonymous]

Im utilizing a table with Alphanumeric item numbers (Item code) and I cannot get to calcuate due to the alpha number item nubmer. Can anyone offer a potential solution. 

calculate(sum(Dims[Cubic Ft])*sum(Inventory[Quantity On Hand]),Dims[Item Code])

[Anonymous]

When attempting to use both of these options im not getting this: 

A single value for column 'Cubic Ft' in table 'Dims' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

With there being multiple locations we have cubic ft in multple locations but throwing a sum on the formula is summing all locations not just that sigular item number. 

[Anonymous]

Hi @Anonymous ,

Please have a try.

Total Cubic Feet = SUMX(Inventory, Dims[Cubic Ft] * Inventory[Quantity On Hand])

This measure will multiply the cubic feet and quantity on hand columns for each row in the Inventory table.

Another possible solution is to create a calculated column.

Cubic Feet On Hand = Dims[Cubic Ft] * Inventory[Quantity On Hand]

Then, you could use this formula to create a new measure called Total Cubic Feet:

Total Cubic Feet = SUM(Inventory[Cubic Feet On Hand])

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.