Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.