Create a variance measure

If a Power BI data mode has two fields for example, in a financial context, you may have Budget and Actual data. This example demonstrates a method for creating a variance (Budget - Actual).

The example assumes the existing data model with a field called Value (dollars) and field called Type (this is a version that holds a value of Actual or Budget).

Variance = 

Var vActual = Calculate ( Sum ( Finance[Value] ), Filter ( Finance, Finance[Type] = "Actual" ) )
Var vBudget = Calculate ( Sum ( Finance[Value] ), Filter ( Finance, Finance[Type] = "Budget" ) )

Return

vBudget - vActual