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. ...
Need Help
  • Michiel's avatar
    Michiel
    7 years ago

    Just start with creating a measure:

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

Michiel's avatar
Michiel
Resolver III
7 years ago
That is correct, 25% of 125 is 30, so the result should be 95.
Michiel's avatar
Michiel
Resolver III
7 years ago
Oops, 31,25 indeed