How do I create a calculate column based of the count of other tables

[jak8282]

Hi,

I am trying to crteate a calculated table  that counts the number of interactions for a date.

See below....how can I create that calculated table?

Thanks for any help.

C

[Anonymous · Accepted solution]

Hi @jak8282,

You can use summarize function to summary the interactions table records and manually append a custom row to summary the second table records.

NewTable =
UNION (
    SUMMARIZE ( interactions, [Type], "Count", COUNT ( interactions[Date] ) ),
    ROW ( "Type", "Call", "Count", COUNTROWS ( Cisco ) )
)

Regards,

Xiaoxin Sheng