Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicers and relationship, help!

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.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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).

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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).