Forum Discussion
Solved
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. N...
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.
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