topic DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by in DAX Commands and Tips

DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by

mkavcic — Wed, 01 Jun 2022 16:00:54 GMT

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

Re: DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by

lbendlin — Thu, 02 Jun 2022 11:52:03 GMT

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

Re: DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by

mkavcic — Thu, 02 Jun 2022 17:19:18 GMT

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

Re: DAX SUMMARIZECOLUMNS ROLLUPADDISSUBTOTAL with parameter for group by

Anonymous — Wed, 15 Jun 2022 05:27:41 GMT

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