Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Having Trouble Creating New Calculated Column

 

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?

 

 

 

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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])

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

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

    Hope this helps.

     

    Best Regards,

    Giotto

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    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