Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two data sets merged into 1 by a join.
in data set A I have complete data for forecast at volume and value level.
in data set B I only have the volumes only which are available for sales.
Sample data set:
I need to calculate the value of the constraint Forecast in value based on following:
- Blanks means the volume and value are same as the unconstraint forecast.
- Value is calculated by dividing value by volume for each SKU. (i m using sumx formula to calculate the value for each line)
For instance for SKU 4, the constraint value is 6000.
And total constraint value across all SKUs is 187,600
I am getting following result when I view it SKU-wise. However, at the total level its not summing up unconstrained + constrained forecast value and just giving a sum of constrained value.
(not based on sample above)
Would really appreciate if someone can help me out on calculating the correct total constraint value!
Hi @Anonymous ,
Try using this measure:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Cumulative-total-of-measure-to-show-in-card/m-p/1906157#M41150
I hope this helps!
Hi Thanks, but this isnt working for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |