Count rows with a condition from 2 tables

[Anonymous]

Hi,

I have 2 tables, let's say Fact1 and Fact2. They both have a column name "Year". I also have a 3rd table which a dimension "Contacts". I have a star schema with a 4th dimension "Calendar".

I need to count the number of rows in the table Contact where this condition is verified : Fact1[Year] = Fact2[Year]

Could you please help me do this in a DAX measure?

Thank you,

[Anonymous]

Hi @Anonymous ,

Could you please provide some sample data(exclude sensitive data) in Fact 1, Fact 2 and Contacts? And is there any relationship created among these tables? If yes, please provide the related info(cardinality, cross-filter direction etc.). Thank you.

Best Regards

[amitchandak]

@Anonymous , Try treatas can help

https://docs.microsoft.com/en-us/dax/treatas-function

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/