Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate discount

Hello all, i am super new to DAX and have been assigned a task to calculate discount based on sum of the value. forexample: The total sum of a column is 125; i want to apply 25% discount on the sum. Any help is appreciated

 

 

Thanks

Need Help
  • Michiel's avatar
    Michiel
    7 years ago

    Just start with creating a measure:

    Discounted Value = SUM(Column[Value]) * 0,75

5 Replies

  • Michiel's avatar
    Michiel
    Resolver III
    7 years ago

    Just start with creating a measure:

    Discounted Value = SUM(Column[Value]) * 0,75

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This DAX doesn't give me result of 100

      • jtownsend21's avatar
        jtownsend21
        Responsive Resident
        7 years ago

        I think you have a math error Anonymous . 

         

        25% of 125 is 31.25. so a 25% discount would give you a total of 93.75.