cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FAA
Helper I
Helper I

Summing calculated column based on IF condition

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:

FAA_1-1624512215097.png


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)

FAA_2-1624512543132.png

 

Would really appreciate if someone can help me out on calculating the correct total constraint value!

2 REPLIES 2
Tanushree_Kapse
Solution Supplier
Solution Supplier

Hi Thanks, but this isnt working for me. 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!