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
