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
4 years ago

Hi,

This measure works

Measure = countax(FILTER(VALUES(Data[Country]),COUNTROWS(Data)>2),Data[Country])

Hope this helps.

AndresOH's avatar
AndresOH
Frequent Visitor
4 years ago

Hello Ashish!

I have the problem that this measure don't let me filter another another date. I need to make the calculation for each month selected in a slicer, this way it's not working, it also doesn't allow me to filter for customer type.

 

  • AndresOH's avatar
    AndresOH
    Frequent Visitor
    4 years ago

    Hi  Ashish!
    Sorry I said something wrong in the last post, the measure allows me to filter by customer type, the problem is that is not filteren by date.

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

      I am very confused about what you want.  Share your tables and clearly show the expected result.