Get count of rows from another table

[Beast]

Hi.., I have two tables where I need to get the count of rows based on condition matches.

ie., Get count of rows From Table 2 where Table 1 [Date] = Table 2[Date] and Table 1[Name] = Table 2[Name].

Need a Calculated Column, since I required to see this column when extracting the report.

Note: Since I have indirect relationship, I was not able to create a direct relationship between two tables.

[v-jianboli-msft · Accepted solution]

Hi @Beast ,

Based on your description, I have created a simple sampe:

Please try:

Column = COUNTROWS(FILTER('Table 2',[Date]=EARLIER(Table1[Date])&&[Name]=EARLIER(Table1[Name])))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[sudhav]

you can use relatedtaable() / related()/userelationship DAX functions to get that...

i guess related() or Relatedtable() will be use in this scenario. once you can try

if it is having relation then you can use crossfilter() DAX function