PowerPivot CALCULATE SUM

[gavs73]

Hi, would appreciate any help with this, I'm trying to do a calculate sum if in PowerPivot, example of how it workls in Excel below, but am unsure how to replicate in PowerPivot. Thanks in advance for any help. Gav.

 

[alansidman]

Cannot manipulate data in a picture. Please use XL2BB to upload sample data.

 

[gavs73]

Company	Date	Flag	Value	Total
1​	03-May-20​	1​	10​	20​
1​	03-May-20​	1​	10​	20​
1​	10-May-20​	0​	5​	0​
1​	11-May-20​	0​	10​	0​
2​	05-May-20​	1​	10​	30​
2​	06-May-20​	0​	5​	0​
2​	05-May-20​	1​	20​	30​
3​	07-May-20​	0​	10​	0​
3​	08-May-20​	0​	10​	0​

 

[alansidman]

You have posted a larger picture and not XL2BB. I cannot determine your formulas from the pictures. Your formula in the first picture cannot be associated with the second posting. Really, help us to help you by providing the necessary information.