Not able to get sum of a calculated measure

[Anonymous]

Hi folks,
My data source is given  below,

            

Result required in Power BI 

Formula for Yield 2018 is, 
IF(AND(Sale 2018<=0,Sale 2019<=0),0,IF(Sale 2018<=0,Sale 2019,0))

I'm not able to get the sum 110 and 50 (Sum of yields) in Power BI.

Please help.

Thank you

[ryan_mayu · Accepted solution]

@Anonymous 

you can try this

Measure = sumx(VALUES('Table'[Customer]),[Yield 2018])

Below is the pbix file for your reference

[ryan_mayu · Accepted solution]

@Anonymous 

Please see the attachment.

[Anonymous]

Thanx @ryan_mayu
Ur solution is working well when all the numbers are positive. 
Can you help me find a solution when number are negative too. I have given a sample data below,

Date	Customer	Sale
1/1/2018	A	10
1/1/2018	B	20
1/1/2018	C	30
1/1/2019	C	40
1/1/2019	D	-50
1/1/2019	E	60
1/1/2019	B	50
1/1/2020	C	40
1/2/2020	F	30
1/3/2020	G	-20

Thank you.

[ryan_mayu · Accepted solution]

@Anonymous 

Please see the attachment.

[Anonymous]

@ryan_mayu 
Thank you! It worked...
How can I dynamically change the yield on year selection on slicer?

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try this workaround,pls see the updated atatchment.

[ryan_mayu · Accepted solution]

@Anonymous 

you can try this

Measure = sumx(VALUES('Table'[Customer]),[Yield 2018])

Below is the pbix file for your reference