Slicers and relationship, help!

[Anonymous]

Hello,

I have a calendar table with all my fiscal info details (year, quater, month, etc) and an Opportunity table with several date fields (created date, closed, expected signature, etc). With that, I have several relationships between these 2 tables:

The actived relationship is between Caledar.date and Opp.Closed/Signature Date. So, if I create a slicer to pick only the closed opps by Fiscal Year, it´s working. Now I need to create a slicer to pick the created opps by Fiscal Year. Is there a way to use a specific relationship for Slicers (such as USERELATIONSHIP)? I need to use the same field (FISCAL YEAR), but now it needs to bring me the opps created, not the closed ones.

[Anonymous · Accepted solution]

@Anonymous,

You would need to create a seperate CALCULATE measure that use USERELATIONSHIP as a filter argument (between created date and your date in the CALENDAR table).