cancel
Showing results for
Did you mean:
Regular Visitor

## Sometimes the infinite symbol

Hi, How are you?.

In a division the result is the correct but at a given moment, the infinity symbol appears. If you observe in the image when that error begins, there is no difference between the previous records with those that start with infinity (21566,70 = 491,60, but, the next: 21527,74 = Infinity symbol).
The fields are of decimal number format. The numerator field is "ValorLibreUtilizacion". The value of the denominator is 43.87, which is calculated in a measure: UltimoValorDolar = CALCULATE (sum ('TYPE_CHANGE (2)' [Change Type]) * (- 1))
Have you ever observed something so strange?.

Thank you, very much.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Sometimes the infinite symbol

Writing test formulas to debug issues is a key concept in DAX that you should adopt widely.

Tips to debug DAX

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
5 REPLIES 5
Highlighted
Super User

## Re: Sometimes the infinite symbol

regardless, it would appear that your measure resolves to zero at the lines that return infinity.    Edit the column and just add the measure to check.  you could use DIVIDE(<numerator>,<denominator>) instead to handle the error.  Better still, don't use a column at all, but write a measure

https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Regular Visitor

## Re: Sometimes the infinite symbol

I have left only the measure of the denominator in the column and, in the record where the infinity symbol appeared, it appears empty !! (picture attached) You were right !, there is a problem with the measure "UltimoValorDolar" (UltimoValorDolar = CALCULATE ( sum ('Tipo_Cambio (2)' [TipoCambio]) * (- 1))) (picture attached of Tipo_Cambio (2)).
I have created a new measure:
LibreUtilizEnUSD = CALCULATE (sum ('STOCK_VALORADO (2)' [ValorLibreUtilizacion])) / [UltimoValorDolar]
and, obviously, the original error also happens.
What might affect the "UltimoValorDolar"?... (Instead of SUM (of this measure) can some other function be used?)

Thank you very much for your help (I'm sorry my English).

Super User

## Re: Sometimes the infinite symbol

Writing test formulas to debug issues is a key concept in DAX that you should adopt widely.

Tips to debug DAX

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Regular Visitor

## Re: Sometimes the infinite symbol

Matt,  Good morning. How are you?.

During this weekend I could not to see your suggestion. Today I will see it, and then, I will answer you by myself I need your help again. Thank You Very Much!!

Regular Visitor

## Re: Sometimes the infinite symbol

Matt, How are you?.

In the end I created another query without grouping it as I had done with the one that brings the last type of change (in this query I bring the exchange rate that has index 0 (zero)). I could not solve the error (unfortunately I could not keep wasting time although later I will try to find the solution).

Matt Thank you very much for the link to do a step by step of a calculated measure / field !.

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 155 members 2,224 guests
Recent signins: