Forum Discussion

mwinkels's avatar
mwinkels
Frequent Visitor
10 years ago
Solved

creating a calculated column between two tables

I'm trying to create a calculated column that counts the number of actions taken by a person. In my case I have two tables. Table 1 has a list of unique email addresses. Table 2 has a list of actions...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago
    MyCount = CALCULATE(COUNTROWS(RelatedTable),RELATEDTABLE(RelatedTable))

    Or

     

    MyCount1 = COUNTX(RELATEDTABLE(RelatedTable),RelatedTable[SomeColumn])

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago
MyCount = CALCULATE(COUNTROWS(RelatedTable),RELATEDTABLE(RelatedTable))

Or

 

MyCount1 = COUNTX(RELATEDTABLE(RelatedTable),RelatedTable[SomeColumn])

 

  • mwinkels's avatar
    mwinkels
    Frequent Visitor
    10 years ago

    That worked. Thanks very much for your help!