Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Multiply Row Level Values by Rate/Measure



Wondering if anyone can help me with multiplying row level values by a rate I derived in a measure. Below is a link to a pbix file I'm working with. See Service Worksheet for this request. This is a data set for a logistics company (dummy dataset).


I've created a measure to calcuate an average rate per stop by adding up revenue for different types of stops and divide it by a total number of stops. See 1.81 in the Service Worksheet. This is the average rate per stop.

RateAvg$/Stop = CALCULATE(SUM('All P&D Tables'[DL STOPS $AMT])+SUM('All P&D Tables'[ECOM STOPS $AMT])+sum('All P&D Tables'[PU STOPS $AMT]))/[TotalStopsSTLMNT]


The goal is to figure out the revenue for each Work Area. I've created a table in the file which lists out all the Work Areas under WA Name field. I want to add another column to this table with result of multiply the 1.81 average rate per stop by the number of stops to an area in each row. The field representing number of stops is Act Del Stps. So values in each row under Act Del Stps column should be multiplied by 1.81.


I've spent all day on this and I'm able to get the total aggregation but it returns blank when trying to break it up by Work Area. Please help.

Regular Visitor

It looks like you need to improve your data model.
if you look into your data the values are not related at the row level. there is no total stop value against any WA name. Try designing your model in a star schema and make the proper relationship between tables.



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors