Forum Discussion

SO's avatar
SO
Helper III
4 years ago

Simple Count issue

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?

 

 

Need Help

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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

  • ManguilibeKAO's avatar
    ManguilibeKAO
    Resolver I
    4 years ago

    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.

  • SO's avatar
    SO
    Helper III
    4 years ago

    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