Forum Discussion

Anan2609's avatar
Anan2609
New Member
4 years ago
Solved

DAX Measure to increase column value

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 suggesti...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anan2609 

    maybe you can try 

    measure=sum(LineTotal )* 1.02

Bhav's avatar
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]