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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.
User | Count |
---|---|
97 | |
77 | |
77 | |
47 | |
26 |