Count Reference tables for a value

[vijendras]

New to DAX. I have 2 tables  1) PrimaryTable  - which has the Id feild and 2)SecondaTable which has multiple rows with ID feild and end_date feild.  Both tables are joined by ID column. I am trying to add a new column on Primary feild which states if the ID is active or not based on the conidtion that there are any records in SecondaryTable with end_date > today for that ID  which states that it is still Active and if no records found is Not Active. 

Thanks in advance

[Greg_Deckler · Accepted solution]

Column = COUNTROWS(FILTER(RELATEDTABLE(EntityHistory),EntityHistory[Date]>TODAY()))

In your first table.

[v-chuncz-msft · Accepted solution]

@vijendras,

You may use DAX below as well.

IsActive =
CALCULATE ( COUNTROWS ( SecondaryTable ), SecondaryTable[end_date] > TODAY () )
    > 0

[Greg_Deckler · Accepted solution]

Column = COUNTROWS(FILTER(RELATEDTABLE(EntityHistory),EntityHistory[Date]>TODAY()))

In your first table.