Forum Discussion

pani_victoria's avatar
pani_victoria
Icon for Helper III rankHelper 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 ...
Need Help
Show and Tell
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
Icon for Helper III rankHelper 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