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'm running into a problem with incorrect totals in my measure despite using a SUMMARIZE formula which based on articles online should fix the issue.
"Forecast Sum" = Forecast on the product family level
"Forecast Split by Item" = with this measure I'm trying to allocate [Forecast Sum] to item level based on bookings in the prior year
With this everything is calculated correctly except that if I add "Workflow" (another level of product hierarchy) to the matrix the total per workflow is not correct (6,810+5,723=12,533 not 14,574):
I tried to fix this with Summarize formula but doesn't change the result:
pbix file: https://fastupload.io/OZS4Z87oPbjVRKa
What am I missing?
Thanks!
Solved! Go to Solution.
Simplify it. Get rid of the SUMMARIZE code
@HotChilli it worked! many thanks for help!
Correct formula:
Try changing
@HotChilli, that's what I tried to do with "Forecast Split by Item_Summarize" measure but it didn't fix the issue
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 |
---|---|
15 | |
10 | |
10 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |