DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by

[mkavcic]

Hi,

I have a parameter _Column1 in which I show possible fields from my Sales table.

Example

DEFINE

VAR _Column1 = TREATAS({@pColumn1}, 'SalesTable'[Columns])

VAR _ResultSet =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP('SalesTable'[Color] ), "ColumnTotal"),
'SalesTable'[Model]

EVALUATE _ResultSet

I would like to specify in paramter the field that would be then used in group by instead of 'SalesTable'[Color]. 
It could be any other field, I select in the parameter.

Example which is not working

DEFINE

VAR _Column1 = TREATAS({@pColumn1}, 'SalesTable'[Columns])

VAR _ResultSet =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(_Column1 ), "ColumnTotal"),
'SalesTable'[Model]

EVALUATE _ResultSet

[mkavcic]

That would be a big improvement for Paginated reports.
Who can we ask, if this is going to be developed?
Thank you!

[v-rongtiep-msft]

Hi @mkavcic ,

Please refer to the following documents.

Create and use the paginated report visual 

Paginated reports in Power BI: FAQ 

If still does not help, please create an idea here and post this link for us to vote for it.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Not sure if Field Parameters are supported for Paginated Reports yet.