Forum Discussion

Green_Cloud's avatar
Green_Cloud
Icon for Helper I rankHelper 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 o...
GENERATESERIES
  • Green_Cloud's avatar
    Green_Cloud
    4 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
Icon for Community Support rankCommunity Support
4 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
Icon for Helper I rankHelper I
4 years ago

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