measure

[Anonymous]

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!

  1. 

[amitchandak]

@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]

@amitchandakThanks for coming through.

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