- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello @DillonMcGough ,
yes, check these videos https://youtu.be/PI52ckgezzA?si=Fqdt2LqzHl8PsaJ9
https://youtu.be/J4317R5BvsA?si=pY9zhiLj2N7_rI1D
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 11-13-2024 10:28 AM | ||
09-27-2024 05:56 AM | |||
12-20-2024 05:04 AM | |||
12-07-2024 02:10 AM | |||
07-24-2024 09:57 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |