Getting Variance Bettwen 2 Weeks, in selected Slicers

[adityo]

Basicaclly i want to created variance using measures, between 2 selected slicers. how can i do this?

example when i type week 22, and week 30

the variance tells the different week 22, and week 30.

[amitchandak · Accepted solution]

@adityo , Try a measure like

measure =
Var _Min = MINX(allselected('Date'), 'Date'[WEEK])
Var _Max = MAXX(allselected('Date'), 'Date'[WEEK])
return CALCULATE(SUM(Table1[Value]), filter(Table1, Table1[WEEK]=_max)) -CALCULATE(SUM(Table1[Value]), filter(Table1, Table1[WEEK]=_min))

[adityo]

Hi @amitchandak ,

after a little adjustment, this is a magnificent solution, thanks a lot

[adityo]

hi @amitchandak ,

thank you for your response, but it seems doesn't work, what mistakes i do?, here are my screenshots

and my measures 

actually the difference should tell me

83.907.505 - 83.479.000 = 428.555

but it seems don't calculate and

83.907.505 - 83.479.000 =  still 83.907.505