cancel
Showing results for
Did you mean:
Highlighted
Helper I

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III

## Re: Calculate discount

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

5 REPLIES 5
Highlighted
Resolver III

## Re: Calculate discount

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

Highlighted
Helper I

## Re: Calculate discount

This DAX doesn't give me result of 100

Highlighted
Responsive Resident

## Re: Calculate discount

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.

Highlighted
Resolver III

## Re: Calculate discount

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

## Re: Calculate discount

Oops, 31,25 indeed

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors