Calculate discount

[rehman1]

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

[Michiel · Accepted solution]

Just start with creating a measure:

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

[rehman1]

This DAX doesn't give me result of 100

[Michiel]

That is correct, 25% of 125 is 30, so the result should be 95.

[Michiel]

Oops, 31,25 indeed

[jtownsend21]

I think you have a math error @rehman1 . 

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