topic Re: GENERATESERIES DAX function not incrementing accurately in DAX Commands and Tips

GENERATESERIES DAX function not incrementing accurately

Green_Cloud — Fri, 19 Aug 2022 14:47:51 GMT

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?

Re: GENERATESERIES DAX function not incrementing accurately

daXtreme — Fri, 19 Aug 2022 19:24:23 GMT

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

Re: GENERATESERIES DAX function not incrementing accurately

v-chenwuz-msft — Tue, 23 Aug 2022 10:06:16 GMT

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.

Re: GENERATESERIES DAX function not incrementing accurately

Green_Cloud — Thu, 01 Sep 2022 16:00:54 GMT

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

Re: GENERATESERIES DAX function not incrementing accurately

v-chenwuz-msft — Wed, 24 Aug 2022 05:45:01 GMT

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

Re: GENERATESERIES DAX function not incrementing accurately

Green_Cloud — Thu, 01 Sep 2022 15:59:13 GMT

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