Sum of table column counts

[Anonymous]

Hi, I have 4 tables, in each there is a column with IT ticket numbers - in each table the column is called 'Number'. I want to count the number of ticket references in each column then total them up to get the total number of ticket references. How would I do this? It's something I could quite easily do in Excel so assume it's similar when creating a measure in Power Bi, but I just can't get it to work.

[Anonymous]

Hi, thanks for the feedback. In the end I did separate counts on each table column so that I could split the counts individually.

[Greg_Deckler]

@Anonymous Maybe:

Measure =
  VAR __TicketNum = MAX('Table'[Ticket Number])
  VAR __Table1 = SELECTCOLUMNS(FILTER('Table1', [Ticket Number] = [Ticket Number]),"__TicketNum",[Ticket Number])
  VAR __Table2 = SELECTCOLUMNS(FILTER('Table2', [Ticket Number] = [Ticket Number]),"__TicketNum",[Ticket Number])
  VAR __Table3 = SELECTCOLUMNS(FILTER('Table3', [Ticket Number] = [Ticket Number]),"__TicketNum",[Ticket Number])
  VAR __Table4 = SELECTCOLUMNS(FILTER('Table4', [Ticket Number] = [Ticket Number]),"__TicketNum",[Ticket Number])
  VAR __Resut = COUNTROWS(UNION(__Table1, __Table2, __Table3, __Table4))
RETURN
  __Result