Forum Discussion
Revenue in matrix
greVia , Multiplication should done at line or you need have common group like order no
revenue= divide(SUM(OrdersRows[TotalValue]),Sumx(values(Order[Order]),calculate(SUM(OrdersRows[Quantity])*SUM(Ordershipped[Quantity_Shipped]))))
refer by the blog for a common level between two tables
I solved the problemi with
SUMX(Ordershipped,Ordershipped[Quantity]*RELATED(OrdersRows[UnitPrice]))thank your reply i found the solution many thanks
Super UsergreVia , Multiplication should done at line or you need have common group like order no
revenue= divide(SUM(OrdersRows[TotalValue]),Sumx(values(Order[Order]),calculate(SUM(OrdersRows[Quantity])*SUM(Ordershipped[Quantity_Shipped]))))
refer by the blog for a common level between two tables
I read part of your blog it is so interesting, thanks.
But I have some doubts:
1) Multiplication should done at line" It means that I should create a column? I didn't understand
2)What is common group (I am looking for on internet but I am not finding), if I use this common group then I can use your formula?
Sorry for questions and thanks