Forum Discussion
How do I subtract value in the same column?
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?
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.
3 Replies
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
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.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
