Forum Discussion
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...
This is what I'm getting:
Hi
Sorry, I wasnt sure if should start a new thread or not, new to alot of this. I have been trying to use the dax provided above but it isn't quite working for me (maybe i misunderstood the dax)
+3 = countax(FILTER(VALUES('Attendance Marks'[External Id]),COUNTROWS('Attendance Marks')>=3),'Attendance Marks'[External Id])
I want to try to return a number for how many times an External ID appears more than 3 times in a table. At the moment it returns how many unique ID's I have which is 39, but i want to know how many ID appear more than 3 times the number will be around 5.
I then need one that will return:
How many ID's occur more than 3 times when the subject is filtered to Registration.
Any help is greatly appreciated!
Hi,
Try these measures
Total = countrows('Attendance Marks')
More than 3 = COUNTROWS(FILTER(VALUES('Attendance Marks'[External Id]),[Total]>=3))
Hope this helps.
Thank you so much for taking the time to help me, can't say how greatful I am! It worked wonderfully!
Helen
You are welcome. If my reply helped, please mark it as Answer.
