Showing results for 
Search instead for 
Did you mean: 

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





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

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 431 members 4,225 guests
Please welcome our newest community members: