dynamic generateseries

[pani_victoria]

Colleagues, I have a problem and I once again ask for help.
I would like to create a parameter from 10000 to 2000000 in increments of 0.01 using the GENERATESERIES function but the file size is too large.
I had the following idea

Is it possible to adjust StartValue and EndValue using a range table?

For example, create a table of ranges and add a filter.

Selecting "up to 100000" would create a table from 1000 to 99999.99, etc.

If this is possible, please help me write the code.

[Anonymous]

Hi @pani_victoria ,

Please try to create a measure with below dax formula:

Measure =
VAR _range =
    SELECTEDVALUE ( 'Table'[Range] )
VAR _start =
    CALCULATE (
        MAX ( 'Table'[StartValue] ),
        'Table'[Range] = _range,
        ALL ( 'Table' )
    )
VAR _end =
    CALCULATE (
        MAX ( 'Table'[EndValue] ),
        'Table'[Range] = _range,
        ALL ( 'Table' )
    )
VAR _result =
    GENERATESERIES ( _start, _end, 0.1 )
RETURN
    IF ( HASONEFILTER ( 'Table'[Range] ), COUNTROWS ( _result ), 0 )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pani_victoria]

This is not exactly what I would like to receive. As a result, a table of values should be obtained in order to then add it to the filter and the user could enter any number in the selected range into this filter

[Anonymous]

Hi @pani_victoria ,

Sorry, so far, to my knowledge, this may not be achieveable.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pani_victoria]

Thanks for the help anyway 😀