Forum Discussion
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. ...
Just start with creating a measure:
Discounted Value = SUM(Column[Value]) * 0,75
Michiel
Resolver III
Resolver IIIJust start with creating a measure:
Discounted Value = SUM(Column[Value]) * 0,75
This DAX doesn't give me result of 100
- jtownsend21
Responsive Resident
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.
- MichielThat is correct, 25% of 125 is 30, so the result should be 95.
- MichielOops, 31,25 indeed
