Forum Discussion
Year Filter for multiple measures simultaneously
Need sample/example data for this.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sorry about that, here is an exmple with sample data:
The three metrics I am using are MQL/SAO/SQO, and each one has their own creation date associated. I created three separate calculated measures with built-in filters to take all records of each that have creation dates of 2018. Meaning MQL creation year=2018 for the MQL metric, and SAO creation year=2018 for the SAO, and so on. These work as they are filtered per measure, but when I apply a page level slicer, I seem to be filtering all records together instead of keeping them separate like the individual calculated measures.
Data with individual calculated measures:
| CY MQL # | CY SAO # | CY SQO # |
| 780 | 640 | 230 |
Data with page-level slicer (incorrect numbers)
This ends up filtering all the data together, and initially filters MQL by 2018, and the SAO and SQO records are then limited to that filter of those 780 records, instead of the whole table and then filtering just by SAO=2018, and same for SQO.
| CY MQL # | CY SAO # | CY SQO # |
| 780 | 191 | 191 |
Hope this helps, but if not let me know, thanks!