Forum Discussion

IanR's avatar
IanR
Icon for Helper III rankHelper III
8 years ago

Count rows in another unrelated table

  I am working in CRM. I would like to create a measure that counts rows in the leads table that contain a particular contact ID from the contacts table. The leads and contacts tables do not have a ...
Need Help
BILASolution's avatar
BILASolution
Icon for Solution Specialist rankSolution Specialist
8 years ago

Hi IanR

 

As an alternative you can try this calculated measure.

 

Total Contacts = 

var cont = FIRSTNONBLANK(Contacts[ContactID];1)

return 

COUNTX
(
	FILTER(LeadSet;LeadSet[ParentContactID.Id] = cont);
	LeadSet[ParentContactID.Id]
)

The result is...(In my case)

 

 

 

I hope this helps

 

Regards

BILASolution