Forum Discussion

pani_victoria's avatar
pani_victoria
Helper III
2 years ago

dynamic generateseries

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.

Need Help
Show and Tell

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      pani_victoria
      Helper III
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.