GENERATESERIES DAX function not incrementing accurately

[Green_Cloud]

Hello All,

I ran into an issue with GENERATESERIES Dax.

I Generate a series like below- 

Adjusted Goal = GENERATESERIES(0, 50000, 1)

I want the user put the input value to see the impact of it on overall performance.

The issue is when the user put 50000, the value show 48651, when the user put 15000, the value shows 14985

But if the user put 50, 100, the value is OK.

Anyone knows what's the solution of it?

[Green_Cloud · Accepted solution]

Sorry for not clarifying it well earlier. I actually wanted to use the generateseries dax value in a slicer to use it as an input value. The issue was when I change the slicer it was not incrementing accurately. I got a solution for that. If you use MAX function in stead of SELECTEDVALUE function it works. Hope that helps to calrify. Thanks

[v-chenwuz-msft]

Hi @Green_Cloud ,

I'm glad your problem was solved. Please mark your answer as the solution so that more people with the same problem as you can find the answer quickly.

SELECTEDVALUE() will check the count of current context, if it has two or more, it will return blank. For more details you can refer this guide.

SELECTEDVALUE function - DAX | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

[Green_Cloud]

Thank you for your input. I marked as the way you suggested. Appreciate it!

[v-chenwuz-msft]

Hi @Green_Cloud ,

I test this function and it works well, please provide more details about your problem. Or you can change the type to Decimal Number.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daXtreme]

I'm afraid that with this amount of info... this question is impossible to answer.