Forum Discussion

mora11's avatar
mora11
Icon for Helper I rankHelper 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 ...
"DAX help"
"DAX"
DAX tables
SUMMARIZECOLUMNS
amustafa's avatar
amustafa
Icon for Solution Sage rankSolution Sage
2 years ago

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
    Icon for Helper I rankHelper I
    2 years ago

    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