tachometer - Removing Infinity

[a_chhibber]

Hi,

The data going to my tachometer is a division of two columns, and some of the values in the denominatior column are zero - which brings the start value of tachometer to infinity.

I do not want to change the data to a measure using IF or DIVIDE and place  0 or 1 as start value. So without doing any change in the data, can I change the widget to remove this infinity in start value?

TIA

[v-yuta-msft · Accepted solution]

Hi a_chhibber,

From your description, it seems you don't want to replace infinity with 0 (or 1), and modify the underlying data model, right?

When you do divide aggregation, you can replace 0 with other value which you want, eg 1:

Measure = Max([Column1])/IF(Max([Column1])=0,1,Max([Column1]))

Regards,

Jimmy Tao