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

     

Komal_chouhan's avatar
Komal_chouhan
Regular Visitor
10 years ago

Hi, I am trying to create a calculated column by using two columns from two different tables in PowerBI desktop. But not able to select second column from other table. Can anybody help me into this?