DAX Delta with variables

Hi Natascha ,

Don't know how you have the setup if you have different columns or a single column from where you select the slicer in my case I have a table with a column with the options to be selected and added the following measure:

Delta = 
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALLSELECTED ( 'Table'[Option] ),
        'Table'[Option] = MAX ( 'Table'[Option] )
    )
)
    - CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table'[Option] ),
            'Table'[Option] = MIN ( 'Table'[Option] )
        )
    )

Be aware that this makes the delta between the max and minimum value so if the user selectes more than two options the delta will be calculated between the first and the last value.

I figured it out!

Audience Growth Rates:=DIVIDE(CALCULATE

(SUM(Data[AudienceTotal]),

FILTER(ALLSELECTED('Calendar'[Date]),'Calendar'[Date]=mAX('Calendar'[Date])))

-CALCULATE(SUM(Data[AudienceTotal]),

FILTER(ALLSELECTED('Calendar'[Date]),'Calendar'[Date]=MIN('Calendar'[Date]))),

CALCULATE(SUM(Data[AudienceTotal]),

FILTER(ALLSELECTED('Calendar'[Date]),'Calendar'[Date]=MAX('Calendar'[Date]))))