cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## Get count of rows from another table

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.

1 ACCEPTED SOLUTION
Community Support

Hi @Beast ,

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

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

2 REPLIES 2
Community Support

Hi @Beast ,

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

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

Helper V

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