SUMMARIZE SUMMARIZECOLUMNS set GroupBy_ColumnName(-s) by variable

[aschram]

Is it possible to set the group by column in a SUMMARIZE or  SUMMARIZECOLUMNS statement?

The basis statement is

EVALUATE
    SUMMARIZECOLUMNS( 
        'Product Category'[Category];
        'Product Subcategory'[Subcategory];
        'Product'[Product Name];
        "Total Sales Amount"; [Sales Amount]
    )


Now I want tot select the group by column by variable (SSRS parameter)

DEFINE
    VAR Choose = "Product" // Select GroupBy columns
EVALUATE
SUMMARIZECOLUMNS (
    SWITCH (
        TRUE ();
        Choose = "Category"; 'Product Category'[Category];
        Choose = "Subcategory"; 'Product Subcategory'[Subcategory];
        Choose = "Product"; 'Product'[Product Name]
    );
    "Total Sales Amount"; [Sales Amount]
)


I've tried several routes (also with TREATAS(), VALUES(), etc.) but without any succes. I also want to avoid creating an SSRS expression in the SSRS dataset.


Any ideas?


Regards Arne