Forum Discussion
GENERATESERIES with dynamic value
I would like to pass a dynamic end value to the GENERATESERIESE function. I have an imported (not calculated table), one of its collumns contains the numbers that i would like to use as the end valu...
Goodmorning Anonymous
Calculated tables cannot read the filter context. What are you trying to acheive is not possible.
I would suggest to create a completely new table as follows https://www.dropbox.com/t/2rv9ENz3TZdvyAXQ
NickolajJessen
Solution Sage
Solution Sage
Could you please show me what is in the Series.Value measure? The code does not work on my end.
- NickolajJessen
Not a measure. just:
GENERATESERIES(1,100,1)
The trick is, that i'm not passing any dynamic parameter into it.
I'm just using the drill through function to get a single Title and using MAX() to get the word count of the selected title.
and from there it's easy to use the measure on the filter and sort away any number from the GENERATE series table, that is below the MAX() measure