Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

measure

Hello Guys,

I am new into PowerBI, and I am struggling to fulfill the below requirement

 

  • Using Matrix in the visualization pane, how do i build a metric to show the following
  • Create a Measure to determine Actual Amount
  • Column 1 - Plan Amount
  • Column 2 – Var Plan (where Var Plan = Amount – Plan)

     

    Hope you can understand my problem and help me out!

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Not sure which cost element id or dept you need for the actual and plan.

    just assumed some ids.

    The example measures are

    Actual = calculate(sum(Table[Value]), filter(Table, Table[Cost element Id] in {181,45}))
    Plan = calculate(sum(Table[Value]), filter(Table, Table[Cost element Id] in {210}))

    var = [Plan] -[Actual]

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandakThanks for coming through.

      How did you arrive at {181,45} for Actual and {210} for Plan