Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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]))
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 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
5 years ago

Yes,  I have an entity called owner_ID (sales person) on both tables.