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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Jmens
Regular Visitor

Dax for : Sum + a fixed value ( if a specific criteria is met ) , Otherwise just sum

Hi All , 

   I am trying to create a measure that adds an absolute value ( which is not in the data model )  when a specific criteria is met .  For example in the table below i want to create a  Sales Forecast measure that adds £100 to the sales if the customer is "B" . 

 

    The +£100 will have to be manually typed in the measure .  Is this possible ? 🙂 

 

Customer Sales Absolute Value (Not in Data model )Sales Forecast 
A10 10
15100115
20 20
Sum 45 145

 

   Any help will be much appreciated !

1 REPLY 1
Jmens
Regular Visitor

Jmens_0-1615286305168.png

 A better picture of the example 🙂

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

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.