Year Filter for multiple measures simultaneously

[gsed99]

Hello,

I am trying to create a Filter (I am thinking in a Slicer) that is a drop-down menu with a choice of available years. The user would be able to select one or multiple years, and based on the years they choose, the data in the table below will adjust.

There are 3 metrics, MQL, SAO and SQO.

Meaning, when the user selects 2017, the table will show all MQL records created in 2017, as well as all SAO and SQO records created in 2017. 
I have run into trouble where the filter is like an AND filter, which filters MQL's for 2017, but then limits the subsequent SAO and SQO data to the subset created by the filtered MQL records.

I want this to be an OR filter, where it treats each metric independently, almost as if they were in different tables, but here they are all in the same table.

Any help will be greatly appreciated!
Thank you,
Greg

[Greg_Deckler]

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

[gsed99]

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!