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

Hi Anonymous 

the variance between which Actual and which Budget? Meaning what are you slicing by? Date?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey tamerj1

     

    The "Actual" and "Budget" come from the scenario column. For example, using the chart above, the "Actual" values would be 5, 7, 3, 4, and 7, and the "Budget" values would be 8, 18, 8 , and 6. I am slicing by month, but I didn't include that column in the above example, as I didn't think it was needed to figure out the equation.

     

    To clarify, the equation would need to filter the Scenario column by either Actual or Budget and pull the amounts from the corresponding column. Please let me know if you need further clarifications via images or what not.

     

    Thanks