Forum Discussion

AndresOH's avatar
AndresOH
Frequent Visitor
4 years ago
Solved

Count Rows When a Value occurs more than X times

Hi everyone! I'am trying to count the rows in a table only when the code of a customer appears more than "x" times. In this particular case the number is 2. Taking as an example the table below, th...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    This is what I'm getting:

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Try these measures

Total = countrows('Attendance Marks')

More than 3 = COUNTROWS(FILTER(VALUES('Attendance Marks'[External Id]),[Total]>=3))

Hope this helps.

hellybobs82's avatar
hellybobs82
Regular Visitor
3 years ago

Thank you so much for taking the time to help me, can't say how greatful I am! It worked wonderfully!

 

Helen

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    You are welcome.  If my reply helped, please mark it as Answer.