Delta between values of same column but different rows

zervino Try:

vs Actuals Measure = 
  VAR __Sales = MAX( 'Table'[Sales] )
  VAR __Actuals = MAXX( FILTER( ALL( 'Table', [Plan] = "Actuals" ), [Sales] )
  VAR __Result = __Sales - __Actuals
RETURN
  __Result

Ooh, look, a Calculate 🙂

vs Actuals = sum('Table'[Sales])-CALCULATE(sum('Table'[Sales]),'Table'[Plan]="Actuals")

Hi zervino,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you lbendlin, for you reply regarding the issue.

By creating this Dax measure you may achieve :

vs Actuals = 
VAR currentMonth = SELECTEDVALUE('SalesData'[Month])
VAR currentCustomer = SELECTEDVALUE('SalesData'[Customer])
VAR actualSales = 
    CALCULATE(
        SUM('SalesData'[Sales]),
        'SalesData'[Plan] = "Actuals",
        'SalesData'[Month] = currentMonth,
        'SalesData'[Customer] = currentCustomer
    )
RETURN
IF(SELECTEDVALUE('SalesData'[Plan]) = "Actuals", 0, SUM('SalesData'[Sales]) - actualSales)

I tested it with  sample data, and it working fine. Please find the attached screenshot and Pbix for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Harshitha.