Hello People, I am newbie to power bi , i need to create to measure which increases LineTotal in the Sales table by 2%here LineTotal is Column , I have attached screenshot ,Any help or suggestion i need to complete the task. Thank u in advance

Anan2609 maybe you can try measure=sum(LineTotal )* 1.02

DAX Measure to increase column value | Microsoft Fabric Community

ryan_mayu
Super User
4 years ago
Anan2609

do you mean creating a column?

column=LineTotal * 1.02

If this not what you want, pls provide the expected output.
- Anan2609
  New Member
  4 years ago
  ryan_mayu No I want to create measure that increases LineTotal column values by 2%,
  
  See this the task to complete, here it is mentioned to create measure(Target sales)
  
  Thank U😊
  - ryan_mayu
    Super User
    4 years ago
    Anan2609
    
    maybe you can try
    
    measure=sum(LineTotal )* 1.02
demouser
Regular Visitor
4 years ago
TargetSales = SUM([LineTotal]) * 2.00
Use this..!
Bhav
Regular Visitor
2 years ago
I am new dax learner, i don't know how we can use all dax in one measure, but i have created multiple measure and got result.
1. Total sales = SUM(Sales[LineTotal])
2. Total sales*2 = [total sales]*2
3. 2% of total sales = [Total sales*2]/100
4. Target = [total sales]+[2% of total sales]