Count number of items in another table without relationship

[albertax]

Hi Team, 

I am unable to join two tables together by their IDs due to ambiguity in a relationship error. So as a way around this, I wanted to do a CALCULATE, FILTER 

countActions = CALCULATE (COUNTROWS('Hazards'), 

FILTER ('Actions',

'Actions' = Hazards'[ID])

)

My Hazards table has a unique ID for the hazard, and then a referenceID which i can relate back to the action. I am wanting to count the number of Actions associated with each Hazard.

Any ideas on how to fix my error? 

[Arul]

@albertax ,

try the below

countActions = CALCULATE (COUNTROWS('Hazards'), 
FILTER ('Actions',
'Actions'[referenceID] = Hazards'[ID])
TREATAS(VALUES('Actions'[referenceID]), Hazards'[ID])
)

Thanks,

Arul