Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
3 years ago

Using "All" in Paginated Report parameter

I am trying to filter a paginated report based on 'Year' and I am appending "All' to a Dataset for use in generating a Parameter.  I am using the following DAX to generate the Dataset for the Parameter:

 

EVALUATE
UNION (
SELECTCOLUMNS (
VALUES ( 'NewAppCalendar'[Year] ),
"Year", [Year],
"Year Value", [Year]
),
ROW ( "Year", "ALL", "Year Value", -1 )
)
ORDER BY [Year Value]

 

I then use the above Dataset to generate a parameter which works well giving me a year parameter with all years in my calender and appended "All".  My question is how do i use or alter my Tablix query to make use of the new parameter to filter my report.

 

Thanking you in Advance.

Chris

3 Replies