Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have the following tables:
Sales with column ProductID, among others
Products with columns ProductID and Price among others.
I need to create a visual that will take the Revenue.
My question is how do I take the Price from the related table?
The same product can appear multiple times in the Sales table and I need to sum this Revenue.
Solved! Go to Solution.
Didn't work for me.
But I figured it out by creating a new column in the Orders table
RevenuePerSale = 'Sales'[Quantity] * related(Products[Item Price])
And then the desired measure: Revenue ($) = sum(Sales[RevenuePerSale])
It's ok to create NEW column, when you don't have much data.
In case you have a lot of data, it will increase storage volume, and, perhaps, slow down calculations.
instead, Try the only measure:
Revenue = sumx( addcolumns( 'Sales'; "new column"; 'Sales'[Quantity] * related(Products[Item Price])); [new column])
Mesaure seems to work well in a table with small dataste. However it takes ages in matrix.
Is there another way which maybe works fatser.
This is the measure I'm using as per your suggetion
and image shows my tables
hi
use this measure:
Revenue = Sum(Sales[Units])*sum('Product'[Price])
And in a visual insert Product (from Product Table) and Revenue.
Didn't work for me.
But I figured it out by creating a new column in the Orders table
RevenuePerSale = 'Sales'[Quantity] * related(Products[Item Price])
And then the desired measure: Revenue ($) = sum(Sales[RevenuePerSale])