Forum Discussion

vijendras's avatar
vijendras
Frequent Visitor
8 years ago
Solved

Count Reference tables for a value

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

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    Column = COUNTROWS(FILTER(RELATEDTABLE(EntityHistory),EntityHistory[Date]>TODAY()))

    In your first table.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    vijendras,

     

    You may use DAX below as well.

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago
    Column = COUNTROWS(FILTER(RELATEDTABLE(EntityHistory),EntityHistory[Date]>TODAY()))

    In your first table.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    vijendras,

     

    You may use DAX below as well.

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