Forum Discussion
Solved
Measure to count values in relational tables
I have 3 tables below Table 1 ID Email 1 [email protected] 2 [email protected] 3 [email protected] 4 [email protected] 5 [email protected] Table 2 ID Email 1 abc@cont...
Hi,
MailCount = CALCULATE( COUNT('Table 1'[Email]), 'Table 1'[Email] IN VALUES('Table 2'[Email]) || 'Table 1'[Email] IN VALUES('Table 3'[Email]) )
lukiz84
Memorable Member
Memorable MemberHi,
MailCount =
CALCULATE(
COUNT('Table 1'[Email]),
'Table 1'[Email] IN VALUES('Table 2'[Email]) ||
'Table 1'[Email] IN VALUES('Table 3'[Email])
)