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

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
Super User
Super User

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().

 

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 117 members 1,633 guests
Please welcome our newest community members: