Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to create a Slicer (Month) with two different tables?

Is it possible to create a slicer that uses the same parameter (MONTH) for two cards that count rows in different tables? I have the same column in both tables (MONTH). For example: I created...
Need Help
  • richbenmintz's avatar
    richbenmintz
    4 years ago

    Hi Anonymous ,

     

    Is there a reason that Lead and Opportunities are related? 

    You can try the following measure to use the inactive relationship defined between MonthTable and view_opportunites

    opp count = calculate(countrows('view_opportunities'), userelationship('monthtable'[Month(Full)],'view_opportunities'[MONTH]))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Actually I did that, and the relationship is between de lead ID in view_leads[ ] and lead_owner_ID in view_opportunities[ ].

 

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Hi Anonymous,

 

Then you can remove your relationship between leads and opportunities and make the relationship between MonthTable and view_opportunities active