Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Figured this out!
Figured this out!
Thank you! Thank you! Thank you!
Hi @Polygon ,
You can use What-IF parameter. For this formula can you provide some sample data ?
Ricardo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |