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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
saipawar
Helper IV
Helper IV

Calculate delta by row in a matrix

Sample Dataset - click here

tab 1 - input dataset 

tab 2 - desired output

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@saipawar , Three measures like

 

Actual = sumx(filter(Table, Table[Source] ="Actual" ), [cost($)])
Plan = sumx(filter(Table, Table[Source] ="Plan" ), [cost($))
Delta = [Plan] -[Actual]

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
saipawar
Helper IV
Helper IV

@amitchandak  The Plan numbers sum is not correct! 

amitchandak
Super User
Super User

@saipawar , Three measures like

 

Actual = sumx(filter(Table, Table[Source] ="Actual" ), [cost($)])
Plan = sumx(filter(Table, Table[Source] ="Plan" ), [cost($))
Delta = [Plan] -[Actual]

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors