bug What If with decimal numbers

[afonsofeliciano]

I have a problem with what if.

A measure was created according to the following DAX: pDolar = GENERATESERIES(0, 20, 0.01)

In short, I need to advance in decimal form every 1 cent of dollars.
However, in my data segmentation, if I type 6.10 the value to be filled is 6.11, in addition, even the value configured in the decimal format with 2 places, this is not being respected as shown in the image below

When I type 6.10

The saved value is 6.11

 In addition, for my demand, which is internal to a company, I cannot leave the slicer.
That is, my look needs to be in this format:

Any way to get around this bug? Has Microsoft already spoken out?
My power bi desktop is in the latest version:

[parry2k]

@afonsofeliciano  Yes I was able to reproduce the issue and it need fix.

[marcos_osorio]

@afonsofeliciano @parry2k 

Same problem for me.

[Anonymous]

A workaround for this issue can be to use casting in GENERATESERIES function as shown by Marco Russo here: https://www.sqlbi.com/articles/generating-a-series-of-numbers-in-dax/.

[afonsofeliciano]

@Anonymous thanks for your contribution.

however, I performed these tests previously, since I found a page here in Brazil with the same content informed by you on this sqldbi website.

When I create the measure 

testMeasure= SELECTCOLUMNS( GENERATESERIES(1, 100, 0.01), "Value", CURRENCY([Value]))

I can solve part of the problem:

part 1: the value of the decimal place, is really fixed in just two places.

part 2 and more importantly: when I type in a certain number, the data segment interprets it as another number. For example, when I type 12, what appears is 11.98. That is, there is no precision in the data input that must be done by the end user.

[deevs]

 HI afonsofeliciano

This is my solution and working like charm 😊

In my scenario user had to enter exchange rate value range between 0.0001 and 999999.9999 and it was very challenging to deal with even given the what if was working perfectly. Coz if you generate a sequence with 1 million rows the pibx file size will go from 5 MB to 1GB which is a efficient at all.

My way you can avoid this bug which rounds off weirdly as well as it won’t increase your pibx file size.

I created four what if parameters. In your situation you might be able to get it done with two parameters.

 Then I concatenated those four value measures as a text and then converted to a decimal number. I have put a screenshot below. Let me know if it doesn’t work I will share you with a pibx template.

Thanks,

Deevs