Forum Discussion

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
3 years ago
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...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    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

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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

  • ReadTheIron's avatar
    ReadTheIron
    Icon for Helper III rankHelper III
    3 years ago

    Perfect! Thank you so much!