topic Re: sumx by week not giving right answer in DAX Commands and Tips

sumx by week not giving right answer

Anonymous — Thu, 17 Nov 2022 22:11:58 GMT

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?

Re: sumx by week not giving right answer

FreemanZ — Thu, 17 Nov 2022 23:15:00 GMT

Anonymous Assumimg [Total] is a column, try this

measure =

SUMX(

VALUES(week nb),

IF (

[gross profit]>0,

CALCULATE(SUM([Total]),

)

Re: sumx by week not giving right answer

Anonymous — Fri, 18 Nov 2022 00:01:18 GMT

Hello FreemanZ thank you for your response unfortunately doesnt work

Re: sumx by week not giving right answer

FreemanZ — Fri, 18 Nov 2022 00:48:56 GMT

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.

Re: sumx by week not giving right answer

Anonymous — Fri, 18 Nov 2022 01:48:22 GMT

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

Re: sumx by week not giving right answer

FreemanZ — Fri, 18 Nov 2022 01:57:48 GMT

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