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 t...
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
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