Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
| A | 10 | 10 | |
| B | 15 | 100 | 115 |
| C | 20 | 20 | |
| Sum | 45 | 145 |
Any help will be much appreciated !
A better picture of the example 🙂
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |