Dax solution to calculate Spread or Diference

[Anonymous]

Hello, I need a solution that helps me calculate the difference between a measure that I created, based on a column I used the following formula to calculate the average of these values ​​when applying some filters on my dashboard

Average Ticker = 

AVERAGEX(

    KEEPFILTERS(VALUES('Vol Delta'[UndrlygInstrm])),

    CALCULATE(MEDIAN('Vol Delta'[VoltlyVal])))

After creating this measure I can create the following graph

After that I would like to create the measure that shows me the difference between these two values ​​​​in the graph

An example would be the red line with the value of 25.02% which would be the subtraction of 52.58 - 27.56

How can I make a formula to calculate this difference ?

[v-rongtiep-msft · Accepted solution]

Hi @Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
VAR _1 =
    CALCULATE (
        MAX ( 'Table'[VALUE] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[subject] = "B"
                && 'Table'[date] = SELECTEDVALUE ( 'Table'[date] )
        )
    )
RETURN
    _1 - MAX ( 'Table'[VALUE] )

If I have misunderstood your meaning, please provide mor details with your desired and pbix file without privacy inofrmation.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous Well, you could create a measure that does a CALCULATE of that measure with a filter of your legend value and then your other legend value and average the two together. You may also find this helpful as this would be even easier to implement because the original average formula would not include that weird CALCULATE construct.

Better Average per Category - Microsoft Power BI Community