Countrows with multiple related filters

Hi Gingerjeans88 ,

For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables, and change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table. Then when you make some changes or interact in someone table, the other table objects will return corresponding matched result.  See more:Create and manage relationships in Power BI Desktop .

Then you may create measure like DAX below.

Count contacts=

var v=SELECTEDVALUE('Open Day Type'[Open Day])

return

COUNTROWS(FILTER(ALLSELECTED(contacts), contacts[campaign response]=v))

Or could you share some data sample and expected output? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

How to Get Your Question Answered Quickly

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.