cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Pass measure result as report filter selection

HI, is there a way to pass a measure result as report filter selection. I have count of passed days in current month  that I need to pass to report filter, but I do not know how to do that. Image.png

 

Thanks, 

Tom

 

1 REPLY 1
jdbuchanan71 New Contributor
New Contributor

Re: Pass measure result as report filter selection

I don't know of way to pass a measure result to a report filter but, guessing at what you are trying to do, could you add a DayOffset to your date table which would show the number of days between whatever date and today then just set the filter on DayOffset = 0.

 

This is a column in my date table:

DayOffset = DATEDIFF( Dates[Date] , TODAY() , DAY )

This column will show 0 for the date 1/31/2019 right now but tommorw it will show 0 on 2/1/2019 since the measure uses TODAY().