Dynamic Date Filtering On Measures

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

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