sumx by week not giving right answer

[Anonymous]

hello everyone ,
i have a calculation 

measure =
VAR value = sum([total])
RETURN
sumx(values(week nb),if ( [gross profit] > 0 , value , 0))

and i have a week slicer .

if i slect week 1, value was 10 but we were on a loss, so gross profit was negative so result of value gives 0 
if i select week 2, value was 20 ,we were on profit, so gross profit was positive so result gives value 20

now if i select week 1 and week 2 together i am not getting getting 20 , iam getting 30. how can i solve this?

[FreemanZ · Accepted solution]

@Anonymous Assumimg [Total] is a column, try this

measure =

SUMX(

    VALUES(week nb),

     IF (

         [gross profit]>0, 

         CALCULATE(SUM([Total]), 

         0

     )

)

[FreemanZ · Accepted solution]

@Anonymous Assumimg [Total] is a column, try this

measure =

SUMX(

    VALUES(week nb),

     IF (

         [gross profit]>0, 

         CALCULATE(SUM([Total]), 

         0

     )

)

[Anonymous]

Hello @FreemanZ thank you for your response unfortunately doesnt work

[FreemanZ]

what error do you get? And if would be good if you could also share the header of your data table, so to avoid spelling issues.  

[Anonymous · Accepted solution]

No error just didnt add up correct but i found a turn around and was able to fix my issue by adding the if to another measure formula that directly affect my formula similar to your suggestion,thank you for your time and help

[FreemanZ]

Glad to hear that.  Solving the problem by oneself with only some hint from others would be the best outcome.