With this code and the attached photo why I get incorrect numebrs for priceforunit last column?!! for example the last column for the first row should be 117556.23/2829 = 41.55

priceofeachunit = DIVIDE(data_sales_20k[20KG_Bag_RevenueEUR],data_sales_20k[20KG_Bag_UnitsSold])

enter image description here

  • $\begingroup$ Usually these errors are when you are using more than one table with missing/improper relationships. Your screen shot needs to be a little wider. What's a column and what's a measure? Which table is DEPARTURETIMEUTC on? If a different table, what is relationship to data_sales_20k? $\endgroup$
    – TheRizza
    Commented Mar 10, 2023 at 16:45
  • $\begingroup$ Also you need to check if the datatype of both of these columns are the same, along the data relationship modelling because that might also be a cause $\endgroup$
    – vignesh_md
    Commented Jul 3, 2023 at 11:58


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.