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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 137 | |
| 102 | |
| 71 | |
| 67 | |
| 64 |