Add ALL to list of values in a Paginated report parameter

Anonymous — Tue, 18 Jul 2023 11:02:32 GMT

Hello All,

I have added ALL as a row value to one of my parameter in paginated report with below DAX.

EVALUATE UNION ( DISTINCT(SELECTCOLUMNS(Projects, "Top_ProjectManager","ALL")) , SUMMARIZECOLUMNS( Projects[Top_ProjectManager], KEEPFILTERS( FILTER( ALL( Projects[Top_ProjectManager] ), NOT( ISBLANK( Projects[Top_ProjectManager] )))) ) )

In my master dataset now I need to make the query work as

By default the parameter value should be selected ALL, so I have made Parameter default values as below.

when ALL is been selected, the report should view all of the values in that column.
If any perticual value selected then the report should filter based on that.

The master dataset query i have written as below

FILTER(VALUES(Projects[Top_ProjectManager]), OR(Projects[Top_ProjectManager] = @ProjectManager, @ProjectManager = "ALL"))

But in dataset properties Parameters query what should i mention i am unable to understand it.

Can anyone please help me wih this.

Thanks,

Mohan V.

topic Add ALL to list of values in a Paginated report parameter in Report Server

Add ALL to list of values in a Paginated report parameter