How to disply Top N based on current Date , Time is in columns also in filter

Questions & Answers
1

I have a report with the below details:
columns
Measure with issue history and Time
Rows
Assignee
Filter
Time

Now I am applying Top N on today date and it is giving correct, if I check the next day top N is still showing as yesterday not today, can any one help here to achive top N based on current Date.

2

Hi,

Try using “Time” dimenion as page filter and create a calculated member for today’s date:
Use this formula for member “Today”:

Aggregate({
	[Time].[day].CurrentDateMember
})

Then select this member in your report page filter and add the TOP n filter for the measure “Issues history”

Martins / eazyBI

Top N filter for measure
Top N filter for measure2204×1162 213 KB