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

[Polygon]

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

[Polygon · Accepted solution]

Figured this out!

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

[Polygon]

Thank you! Thank you! Thank you!

[camargos88]

Hi @Polygon ,

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

Ricardo