Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jamie_Hughes
Frequent Visitor

GENERATESERIES not selecting certain number in the range

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.

1 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 Smiley Very Happy

 

View solution in original post

8 REPLIES 8
EvgeniAb
Regular Visitor

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
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Stachu
Community Champion
Community Champion

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?


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

@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

 

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 Smiley Very Happy

 

is there any solution of it so far?

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

@Jamie_Hughes

 

I cannot replicate it either.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors