Forum Discussion
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!
2 Replies
- amitchandakSuper User
NoordenNL076 , Can you create a new column in fact
example
= [Qty] * related (Dim[Volume])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8- NoordenNL076Regular Visitor
amitchandak , made a column but for some products it gave the incorrect maximum volume. Do you have another method? Thanks