Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have 5 tables, Date, Sizes, Production, Expenses & Operations. The last 3 are fact and the rest are dimensions to generate report like below.
I have a chart currently showing my daily production vs the budgeted. What I now want to create is a chart that allocates the total expense for the day over the unit of those that are produced that day. We currently produce 3 sizes battens of the same length. I tried using:
=CALCULATE(SUM(Expenses[Payment])/SUMX(ALL(Production),SUM(Production[Total]))*SUM(Production[Total]))
But this is not giving me the correct report. The report that I want would be formatted as Sizes used as filters with Date as categories and said measure as value. However, I do not know how to correctly calculate the cost per unit belonging to the size produced during the day.
P.S. Crosspost from Excel forum as I was asked to post this question here.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |