I have a table of budget and actual information. I want to be able to only show the diference--my Over/(Under) column on the right. I don't need to know see the variance in the actual column. How can I go about structuring this? Does my quick measure need to be tweaked?
1 ACCEPTED SOLUTION
@Anonymous,
Try these measures:
Actual Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Actual" )
Budget Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Budget" )
Over/(Under) = [Budget Dollars] - [Actual Dollars]
Create matrix visual:
@Anonymous,
Try these measures:
Actual Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Actual" )
Budget Dollars = CALCULATE ( SUM ( 'f_SAP_BPC_O&M'[Dollars] ), 'f_SAP_BPC_O&M'[Version] = "Budget" )
Over/(Under) = [Budget Dollars] - [Actual Dollars]
Create matrix visual:
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
