Forum Discussion

New Member

5 years ago

Solved

Revenue in matrix

Hello, I need to have a matrix with total revenue measure as Revenue =Unit_Price*Quantity the problem is that these fields are in two differente table. My db is: Orders ordersRow OrdersShi...

Need Help

amitchandak
5 years ago
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

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
greVia
5 years ago
I solved the problemi with
SUMX(Ordershipped,Ordershipped[Quantity]*RELATED(OrdersRows[UnitPrice]))

thank your reply i found the solution many thanks