Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating a Measure using different filtered values from the same column

Hello all,   I am pretty new to Power BI and am not very experienced in creating measures using DAX commands so I apologize if my terminology is a bit off.   I am trying to create a measure that ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Please try

    =
VAR Actual =
    CALCULATE ( SUM ( [Amount] ), [Scenario] = "Actual" )
VAR Budget =
    CALCULATE ( SUM ( [Amount] ), [Scenario] = "Budget" )
RETURN
    DIVIDE ( Actual - Budget, Actual )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

You ca use

CALCULATE ( 

SUM ( [Amount] ),

[Scenario] = "Actual"

) - 

CALCULATE ( 

SUM ( [Amount] ),

[Scenario] = "Budget"

)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Perfect this works thanks so much. What would I need to add to the code in order to get % variance? I tried adding the below code to the end but it said my syntax is wrong.

    / CALCULATE(
    SUM([Amount]),
    [Scenario] = "Actual"
    )
     
    Thanks again
     
    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Anonymous 

      Please try

      =
VAR Actual =
    CALCULATE ( SUM ( [Amount] ), [Scenario] = "Actual" )
VAR Budget =
    CALCULATE ( SUM ( [Amount] ), [Scenario] = "Budget" )
RETURN
    DIVIDE ( Actual - Budget, Actual )