Forum Discussion
Dynamic Date Filtering On Measures
Hello,
I am trying to figure out the best way to filter down data on calculations across tables. The specific filtering should dynamically change based on the selection of a Period (such as January 2019) and Timeframe (such as Fiscal Year). I currently have this working using the CALCULATE function, but was wondering if there was a cleaner way of doing this filter across multiple measures.
Is there a way to dynamically apply this filter on a visual/page/report basis?
Attached is a sample .pbix with my current solution using CALCULATE. Again, I would like to be able to set up a visual, page, or report level filter instead of having to create an additional CALCULATE measure for each calculation I am trying to do.
https://drive.google.com/open?id=1nHMFKvD4unFdpyVkYG_oLQxSZll1QCdy
Hi Anonymous,
Unfortunately, it is not supported to apply dynamical filter dimentions based on slicer selection to visual/report/page level filters. As of now, using a conditional measure is the best choice.
Best regards,
Yuliana Gu
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Unfortunately, it is not supported to apply dynamical filter dimentions based on slicer selection to visual/report/page level filters. As of now, using a conditional measure is the best choice.
Best regards,
Yuliana Gu