Forum Discussion

NoordenNL076's avatar
NoordenNL076
Regular Visitor
4 years ago

Measure is not calculating correctly

Hi all,

 

I'm trying to work out how much space products will take up. Basically, Power BI needs to multiply a QTY measure with product dimensions (i.e. volume). The volume is connected to the product Material ID. So every product name has a unique value and then its Material ID. I noticed Power BI was not calculating correctly because the sum of the total volume over all products was far too low. Then I added the volume per product to a visualized table to see what was wrong and saw this:

 

 

The measure should calculate the "New Max QTY" * "Volume". The volume is located in "Dimensions per material and the product and material ID is locatied in "MLGT". The New Max QTY is a measure. My relationship model looks like this: 

 

 

Is there something wrong with my table or is Power BI not recognizing the material or product ID? I really could use some help.

 

Thank you!