Simple Count issue

[SO]

This seems like a simple issue, but I can't seem to find out how to include a Count within a count

Measure = COUNTROWS(Table2)

Var= CALCULATE(COUNTROWS(Table1), Filter(ALLSELECTED(Table1[field], count(Table2[field]) = Measure))) 

I can see that max or min works, but the Bold does not.

Thoughts?

[SO]

Thank you for the response.  I might have a solution using RankX, so I'll experiment some more first.  As I can't use some functions e.g., Earlier (Live Data issue), I'm trying to find a work around.   Thanks 

[ManguilibeKAO]

Hi,

Could you give us input data and the output you want to have, and explain the logic that leads you to the output data?

Best regards.

[v-easonf-msft]

Hi, @SO 

Your code is a bit messy and the basic syntax is inaccurate.Is there a relationship between these two tables?
Please show your dsqmple data and expected results in the table.

This will help us better understand your problem.

Best Regards,
Community Support Team _ Eason