Calculating Multiple Measures

DillonMcGough · ‎12-13-2023

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

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

TAble of the counts (please excuse the naming)

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

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.