Dynamic difference between two selected field parameter measures

[L_G]

Hi,

I need help writing a DAX measure in which I have to calculate the difference between two selected measure in a field paramenter slicer.

Do I have to create a calculation group in Tabular Editor? If yes, can you guide me on how to do it?

es. Selecting EBITDA for the current year and the EBITDA of the previous year from the filter parameter slicer, I need to have the difference between theese two selected measure.

I Need to have this difference measure to be dynamic, based on the selected measere in the field paramenter slicer.

Can anyone help me??

Thanks in advance,

Luca

[klaman]

I solved it by creating two measures that shows the selected value order from the field parameters: 

Parameter 1 = SELECTEDVALUE('Parameter1' [order])

Parameter 2 = SELECTEDVALUE('Parameter2' [order])

Then I created a Switch measure that looks a the above chosen values and their order: 

Difference = 

SWITCH(

    TRUE(),

    [Parameter1] = 6 && [Parameter2] = 0, [Selected measure for parameter 1] - [Selected measure for parameter 2],

    [Parameter1] = 5 && [Parameter2] = 1, [Selected measure for parameter 1] - [Selected measure for parameter 2]

  etc)

[L_G]

HI @some_bih 

I need to have a dinamyc measure that appears only if I select those 2 measures in the field parameter slicer.

In the field parameter slicer I have multiple measures that don't need this "Difference AC - AP" measure to be showed.

[some_bih]

Hi @L_G simple measure like below is ok for you?

Difference test= [EBTDA]-[EBTDAP]