Base Unit of Measure

I am running the Stock overview query and for some plants I get an asterix in some of the key figures for example "Quantity Total Stock"

We have found out that this is because there are mixed units of measure i.e. pcs, kg etc. What is the best way for me to overcome this so that the values are shown? Thanks