How do I subtract value in the same column?

[SamfarUK]

In my data set the first column identifies a KPI e.g. budget, actual, risk. The second column has the values (GBP).

The report currently has 3 cards that shows the values for each of these KPIs. 

Now I need a 4th card which shows the value of [budget - (actual + risk)].

How do I do this please? 

[fahadqadir3 · Accepted solution]

@SamfarUK Review the attached screenshot and measure to calculate [budget - (actual + risk)].

Budget = SUMX('Table',

CALCULATE(SUM('Table'[GBP]),'Table'[KPI] = "Budget")
)

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

[SamfarUK]

hi, thanks for your reply

i don't want a table though, here is a snippet (partial) of my report, so you can see where i need the variance box

[HoangHugo]

Not clear your post. I think you need 3 separate measure calulate sum of Budget, Actual, Risk. Then make an calculate  [budget - (actual + risk)] to have 4th card