Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SELECTEDVALUE multiple objects

Hello colleagues! Looks like I have a common issue with = SELECTEDVALUE returning only single value, whereas I need multiple values shown:  Are there any ways to simplify the solutins? I met s...
Need Help
Show and Tell
  • Alex87's avatar
    Alex87
    2 years ago

    correct, you cannot filter if you use CONCATENATEX.

    For what you want to achieve you need something close to this

     

     

    VAR _Selection = VALUES('NEWDataMonth Current'[Month])
VAR CurrentCost = 
    IF(
        ISBLANK(SELECTEDVALUE('NEWDataMonth Current'[Month])),
        CALCULATE(
            [MainSumCost],
            FILTER(
                'DatabaseNEW',
                'DatabaseNEW'[Source] = SELECTEDVALUE('NEWDataVersion Current'[Source])
                && 'DatabaseNEW'[Date].[Month] IN _Selection
            )
        ),
        CALCULATE(
            [MainSumCost],
            FILTER(
                'DatabaseNEW',
                'DatabaseNEW'[Source] = SELECTEDVALUE('NEWDataVersion Current'[Source])
                && 'DatabaseNEW'[Date].[Month] = SELECTEDVALUE('NEWDataMonth Current'[Month])
            )
        )
    )
RETURN
    CurrentCost

     

     

Alex87's avatar
Alex87
Icon for Solution Sage rankSolution Sage
2 years ago

correct, you cannot filter if you use CONCATENATEX.

For what you want to achieve you need something close to this

 

 

VAR _Selection = VALUES('NEWDataMonth Current'[Month])
VAR CurrentCost = 
    IF(
        ISBLANK(SELECTEDVALUE('NEWDataMonth Current'[Month])),
        CALCULATE(
            [MainSumCost],
            FILTER(
                'DatabaseNEW',
                'DatabaseNEW'[Source] = SELECTEDVALUE('NEWDataVersion Current'[Source])
                && 'DatabaseNEW'[Date].[Month] IN _Selection
            )
        ),
        CALCULATE(
            [MainSumCost],
            FILTER(
                'DatabaseNEW',
                'DatabaseNEW'[Source] = SELECTEDVALUE('NEWDataVersion Current'[Source])
                && 'DatabaseNEW'[Date].[Month] = SELECTEDVALUE('NEWDataMonth Current'[Month])
            )
        )
    )
RETURN
    CurrentCost

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you! That worked perfectly. Have a nice day!