Count rows with a condition from 2 tables

Question

Hi,&nbsp;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".&nbsp;I need to count the number of rows in the table Contact where this condition is verified : Fact1[Year] = Fact2[Year]&nbsp;Could you please help me do this in a DAX measure?Thank you,

amitchandak · Answer

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/

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
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

Forum Discussion

Count rows with a condition from 2 tables

2 Replies

Related content

Count rows with condition

Counting nulls

Conditional Formatting on Count %RT

How to get Count from two different table- Un-match Count Table Record with New Table

Conditional count