Reply
DillonMcGough
New Member
Partially syndicated - Outbound

Calculating Multiple Measures

we are in the process of working on setting up Activity Based Costing,we have a large data based using 20-30 different reports regarding sales, bids, orders all tied to the bill to customers. we have created multiple measures using all the data to calculate the numbers of bids, number of orders number of lines, number of invoices, deliveries, etc.

These all reside in their own section, no table as they are formulated numbers based on multiple sheets. When added into a table or matrix on the report view the measures do not total, I can not add a total nor create a "total" measure which to combine all of them with a total.

In theory we would like to create a table which shows the Counts of each catagory, then the assocated costs of each of those counts (using a third table we can update for the costs) and then have a total of the costs. 

All of our cost measures

Measures.png

matrix displaying the costs (these are the measures with the individual costs multiplied within the measure)

Measures2.png

TAble of the counts (please excuse the naming)

  

Counts.png

Excel example, of what we are looking to do within Powerbi.

 

ABC Costing.png

 

the measures work great for the data, but visually they are very resctricting and we cant really edit the layout, so any help would be greatly appreciated. I can provide more detial if needed. Biggest issue we have found is cause the meausres are created, they calculate items that we dont have in specific columns, example - a distinct count of any non stock order (which is counting the distinct order number, then if it was non stock or stock) which is mutliple columns on our consolidated data table. all the examples I keep finding are a measure of total sales in X country. 2 distinct columns on the data table. 

 

1 REPLY 1
Idrissshatila
Super User
Super User

Syndicated - Outbound

Hello @DillonMcGough ,

 

yes, check these videos https://youtu.be/PI52ckgezzA?si=Fqdt2LqzHl8PsaJ9

https://youtu.be/J4317R5BvsA?si=pY9zhiLj2N7_rI1D

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)