Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I am working to create a dashboard that includes the sums of a large number of already calculated consolidated measures. (reference we are calculating, total number of orders, bids, etc per a specific company, consolidated over 15-20 data points we import weekly) with 24 total measures which are already created within the data. Each of these measures have an assocated costs we are looking to calculate. I have created the cost table within the data as its own data set. I am having trouble making the calculation between the count of a measure and the price per individual item within the data. example. 10 Bids, at $30 per bid, making the output $300.00 for the bids generated over the course of the year for a specific account.
any help would be greatly appreciated.
Please provide some sample data and show your desired result.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 53 | |
| 42 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 122 | |
| 106 | |
| 47 | |
| 30 | |
| 24 |