Sumx IF sum

[XTREMEITA]

Hellow, i am new user from Br,

I need prevision value based in the period prevision, 

IF(SUM(DATA(VALUE)=0;CALCULATE(SUM(DATA[VALUE])/SUM(DATA[PC]);PREVIOUSMOUNT(DATA[DATE]))*SUM(PREVISION[Period]);SUM(DATA[VALUE])) but, totaly error

Thanks

[Anonymous]

I believe this is what you are trying to do. 

https://community.powerbi.com/t5/Desktop/DAX-SUM-with-GROUP-BY/m-p/704106#M339870

[amitchandak]

@XTREMEITA , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.