Forum Discussion

mora11's avatar
mora11
Helper I
2 years ago

SWITCH over SUMMARIZECOLUMNS based on parameter value

Hello, I have created parameter and based on that I would like to calculate dynamic table using SUMMARIZECOLUMNS function. Is that possible at all? Below you can find my DAX idea using SWITCH and IF however it does not work. I need a table as a result of SWITCH / IF statement.

 

EVALUATE
SWITCH (
    TRUE (),
    @Selected_Values = 0, SUMMARIZECOLUMNS ( 'Test Table'[Column] ),
    SUMMARIZECOLUMNS (
        'Test Table'[Column],
        KEEPFILTERS (
            FILTER (
                ALL ( 'Sources'[Source] ),
                PATHCONTAINS ( @Source, 'Sources'[Source] )
            )
        ),
        "Calculation", COUNTROWS ( 'Test Table' )
    )
)

 

And with IF:

EVALUATE
IF (
    @Selected_Values = 0,
    SUMMARIZECOLUMNS ( 'Test Table'[Column] ),
    SUMMARIZECOLUMNS (
        'Test Table'[Column],
        KEEPFILTERS (
            FILTER (
                ALL ( 'Sources'[Source] ),
                PATHCONTAINS ( @Source, 'Sources'[Source] )
            )
        ),
        "Calculation", COUNTROWS ( 'Test Table' )
    )
)

 

Thanks

2 Replies

  • amustafa's avatar
    amustafa
    Solution Sage

    EVALUATE
    IF (
    @Selected_Values = 0,
    SUMMARIZECOLUMNS ( 'Test Table'[Column] ),
    SUMMARIZECOLUMNS (
    'Test Table'[Column],
    KEEPFILTERS (
    FILTER (
    ALL ( 'Sources'[Source] ),
    PATHCONTAINS ( @Source, 'Sources'[Source] )
    )
    ),
    "Calculation", COUNTROWS ( 'Test Table' )
    )
    )

    • mora11's avatar
      mora11
      Helper I

      Unfortunately this is the same I have pasted. To be clear on this, I need a table as a result of SWITCH / IF statement. Thanks