Sumx and row context

[Anonymous]

Hi 

Suppose i've got a sales table with detail about products etc.. and 3 years (2018 / 2019 / 2020)

Here's my issue, i need to perform that kind of calculation :

   1 - do a classic sumx on my dataset, let's say sum by year of QTTE by PRICE

2018 - 10 000

2019 - 11 500

2020 - 20 000

   2 - then divide these sumx measure by the value i got for 2018

2018 - 1      (10 000 / 10 000)

2019 - 1.15

2020 - 2

Because of the sumx that stick me with the row context, the classic   CALCULATE(result ; year = 2018)    doesn't work.

I hope i'm clear enough.

Thank you guys

Stephane

[parry2k · Accepted solution]

@Anonymous not sure what the issue or what is not working

following measures will work

Total Sum = SUM( Table[Column] )

Sum 2018 = CALCULATE ( [Total Sum], All(Table), Table[Year] = 2018 )

Ratio = DIVIDE( [Total Sum], [Sum 2018] )

[Anonymous]

Hi @parry2k 

i found the problem :

i was using VARIABLES and that was disrupting my calculations.

----

WRONG_RESULT =

     VAR Total Sum = SUM( Table[Column] )

     VAR Sum 2018 = CALCULATE ( [Total Sum], All(Table), Table[Year] = 2018 )

     VAR Result = DIVIDE( [Total Sum], [Sum 2018] )

     RETURN Result

The [Sum 2018] wasn't correct.

CORRECT_RESULT =

     VAR Sum 2018 = CALCULATE ( SUM( Table[Column] ), All(Table), Table[Year] = 2018 )

     VAR Result = DIVIDE( [Total Sum], [Sum 2018] )

     RETURN Result

I tried to upload my dummy.pbix file but i didn't find where to attach it...

[Anonymous]

mmmh i should have tried this before asking you : building a dummy pbix to show you my issue.
 
While doing it i realize that my issue does not come from the formula as the CALCULATE(sumx;filter) is working fine indeed.
 
Well now i know i need to focus elsewhere to debug the **bleep** thing.
 
Thanks for your help !