Forum Discussion

Green_Cloud's avatar
Green_Cloud
Helper I
4 years ago
Solved

GENERATESERIES DAX function not incrementing accurately

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?
GENERATESERIES
  • Green_Cloud's avatar
    Green_Cloud
    3 years ago

    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

5 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    4 years ago

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    3 years ago

    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.

  • Green_Cloud's avatar
    Green_Cloud
    Helper I
    3 years ago

    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's avatar
      v-chenwuz-msft
      Community Support
      3 years ago

      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's avatar
        Green_Cloud
        Helper I
        3 years ago

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