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

Win a FREE 3 Day Ticket to FabCon Vienna. Apply 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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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