The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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
Hi,
Please try to change your original relationships filter direction to 'Both':
Hope this helps.
Best Regards,
Giotto
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])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
142 | |
109 | |
107 | |
76 | |
61 |
User | Count |
---|---|
276 | |
129 | |
124 | |
100 | |
89 |