Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Solved! Go to 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
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))
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
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
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
is there any solution of it so far?
I have the same problem still on Feb 2022 version.
Thank you for clarifying your findings.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |