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
Anonymous
Not applicable

Wrong Matrix Total values

blackbranded_0-1675076743885.png

 

The matrix table is giving wrong calculations for the sub-category. I'm trying to get the remaining budget, but it's giving me the total remaining budget values instead. Can anyone help me?

Variance = var test =  SUMX('calculate',[Planned Budget]) - SUMX('calculate','calculate'[Actual Budget])return IF(ISBLANK(test),0,test)



1 REPLY 1
ribisht17
Super User
Super User

What about using SUM only, not SUMX ?

 

Regards,

Ritesh

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.