Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SamfarUK
Regular Visitor

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? 

1 ACCEPTED SOLUTION
fahadqadir3
Responsive Resident
Responsive Resident

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

Budget = SUMX('Table',

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

 

 

Actual budget.pngnew.png

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.

View solution in original post

3 REPLIES 3
fahadqadir3
Responsive Resident
Responsive Resident

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

Budget = SUMX('Table',

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

 

 

Actual budget.pngnew.png

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

SamfarUK_0-1717509297987.png

 

HoangHugo
Solution Specialist
Solution Specialist

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.