Forum Discussion
Solved
Measure to count repeats
I have a table of equipment failures. I want to count the number of pieces of equipment that failed more than once in a given timeframe (driven by user/slider on page). My data looks something li...
Please try this measure expression. Replace Failures with your actual table name.
Equipment MT1 Failures = VAR tSummary = SUMMARIZE ( Failures, Failures[EquipmentName], "cCount", COUNT ( Failures[EquipmentName] ) ) RETURN COUNTROWS ( FILTER ( tSummary, [cCount] > 1 ) )Pat
Hope this helps:
This works on the sample data but not on my full set - I'm trying to figure out why! Is there a way of doing this without reference to the equipment area?