Simple Count issue

SO · ‎06-09-2022

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 · ‎06-14-2022

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 · ‎06-13-2022

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 · ‎06-13-2022

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