Calculate positive and negative delta

[theunissenp]

Dear all,

I am trying to calculate a delta between selected planning versions. I am able to calculate the absolute delta but i am not able to calculate if this delta is a negative or possitive deviation.

Used measure:

Delta =

VAR SelectedVersion= VALUES('Planned_version'[Planning version])

VAR Minvalue= MINX(

    SelectedVersion,

    CALCULATE(

        [Planned value]))

VAR Maxvulue=

    MAXX(SelectedVersion,

    CALCULATE(

        [Planned value]))

VAR Difference =

IF(Maxvulue > Minvalue,

(Maxvulue-Minvalue)*-1,Maxvulue-Minvalue)

RETURN

    Difference

   Desired result:

Product	1	2	Delta
city bike	10	20	10
Cross bike	40	0	-40
Mountain bike	20	50	30
Race bike	50	5	-45

Current result

Product	1	2	Delta
city bike	10	20	10
Cross bike	40	0	40
Mountain bike	20	50	30
Race bike	50	5	45

SAmple PBIX is attached. 

thanks for your comments

Regards,

Paul

Sample PBIX 

[CNENFRNL]

[theunissenp]

Thanks for your reply. The problem is this solution is that de planning version is selected by a slicer. In the example data there are only 2 but in real life a new version is created every day.