Having Trouble Creating New Calculated Column

[Anonymous]

Hi Folks,

Can someone have a look at the ERD above and advise. I am sure it is only something small.

We are trying to create a new Calculated Column that multiplies Product_Vendors[Margin] * Customer_Order_Details[QuantityOrdered] but Power BI dosent seem to want to let us do it.

We are trying to use the formula related table, but it just seems to be working from child to parent values.

Any ideas?

[v-gizhi-msft]

Hi,

Did my last reply solve your issue?

If my answer has solved your issue, please mark it as a solution for others to see.
Thanks!

Best Regards,

Giotto

[v-gizhi-msft]

Hi,

Please try to change your original relationships filter direction to 'Both':

Hope this helps.

Best Regards,

Giotto

[amitchandak]

Try like

sumx(summarize(Product,product[product_id],"_1",sum(Customer_Order_Details[QuantityOrdered] ),"_2",max(Product_Vendors[Margin])),[_1]*[_2])

OR

sumx(summarize(Product,product[product_id],"_1",sum(Customer_Order_Details[QuantityOrdered] ),"_2",sum(Product_Vendors[Margin])),[_1]*[_2])