Forum Discussion

chris_jones's avatar
chris_jones
New Member
6 years ago
Solved

Counting text values that are with a linked table

Hi

 

I have two tables which are linked.

 

I am trying to ascertain count from one table (The Main Data) to a reference table containing 12 codes)

 

This code bring back the count of the codes with "FC" in it but i need to reference the table containing the list of 12

 

CountDispositions =
CALCULATE ( COUNTROWS ( 'DataTable' ), 'DataTable'[Code] = "FC" )
 
Any help in amending the formaule to accomondate.
 
Thank you
 
  • chris_jones ,not very clear

     

    you can data from the one table to another

    minx(filter(table1, table1[user] =table2[user]), table1[projenddate_date])

1 Reply

  • chris_jones ,not very clear

     

    you can data from the one table to another

    minx(filter(table1, table1[user] =table2[user]), table1[projenddate_date])