Counting text values that are with a linked table

[chris_jones]

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

[amitchandak · Accepted solution]

@chris_jones ,not very clear

you can data from the one table to another

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