Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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-msft's avatar
    v-yulgu-msft
    Microsoft 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