Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Thanks,
Tom
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().
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |