GENERATESERIES not selecting certain number in the range

[Jamie_Hughes]

Hi,

I have a GENERATESERIES from 0 to 1501 in increments of 1, the issue I am having is when I try and select some numbers. For example, when I enter 500 it returns 499, when I enter 14 it returns 13. There doesn't seem to be a pattern to this, here is the DAX I am using "RCM = GENERATESERIES(0, 1501, 1)", any help on how to fix this will be greatly appreciated.

[EvgeniAb]

As an idea that could help to expand range 

GENERATESERIES = UNION( GENERATESERIES(1,499,1), GENERATESERIES(500,999,2), GENERATESERIES(1000,9990, 10),GENERATESERIES(10000,100000, 100))

[v-yulgu-msft]

Hi @Jamie_Hughes,

Function GENERATESERIES worked fine on my side. Please close your desktop and re-create a new .pbix file for a test. Also, you could update your desktop version for a try. If problem persists, please share your sample .pbix file so that we can check.

Regards,

Yuliana Gu

[Stachu]

I cannot replicate the issue - how do you select value from the table? using slicer? also what's the syntax for the measure that returns the value lower by 1?

[Jamie_Hughes]

@v-yulgu-msft, @AlB, @Stachu

I used the what if measure and set the parameters to

Data type = Whole number

Minimum = 0

Maximum = 1501

Increament = 1

I have changed the data type to Decimal number and Fixed decimal number and I still get the same issue

[Jamie_Hughes · Accepted solution]

I found out what the issue was in case anyone stumbles across this post with the same problem.

The reason why some of the numbers don't appear and revert back to another number when entered is due to PBI sampling the data, the range that you are using is to big.

From what I have noticed is that any thing over a range of a 1000 numbers PBI will sample this data and only hold up to 1000 numbers, now these numbers will not be in sequence, this is why you see a different number after you have entered a number in the selection box.

Hope this helps someone as I was struggling to get an answer for it for ages

[Green_Cloud]

is there any solution of it so far?

[jspwilli]

I have the same problem still on Feb 2022 version.
Thank you for clarifying your findings.

[AlB]

@Jamie_Hughes

I cannot replicate it either.