cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Measure - Dax Formula to sum a column and multiply by a manually entered whole number

Target = CALCULATE(product('AMR AR Aging as of 20191206'[Open Balance])*.30)

I need to calculte the sum of total open Balance and then multiply (product) that by 30% and use as a target on a gauge.

What is being returned is the word "infinity" instead of a number

Open balance is a 300 line list of whole numbers

I've tried multiple formula's i.e. Sum but have not had any luck.

Any assistance that can be provided would be grealy appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I

## Re: Measure - Dax Formula to sum a column and multiply by a manually entered whole number

Figured this out!

Target = sum('AMR AR Aging as of 20191206'[Open Balance])*.30
3 REPLIES 3
Highlighted
Community Champion

## Re: Measure - Dax Formula to sum a column and multiply by a manually entered whole number

Hi @Polygon ,

You can use What-IF parameter. For this formula can you provide some sample data ?

Ricardo

Ricardo

Highlighted
Helper I

## Re: Measure - Dax Formula to sum a column and multiply by a manually entered whole number

Figured this out!

Target = sum('AMR AR Aging as of 20191206'[Open Balance])*.30
Highlighted
Helper I

## Re: Measure - Dax Formula to sum a column and multiply by a manually entered whole number

Thank you! Thank you! Thank you!

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.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors
Users online (1,142)