Help with a measure to count

Hi, i have been trying to figure this out but no luck. this is sample data: Date of update Task 10/01/2024 A 15/01/2024 A 15/01/2024 B 23/01/2024 C 10/02/2024 A 28/02/2...

Need Help

DataInsights

1 year ago

fael_66,

Try these measures:

Tasks updated once = 
VAR vTable =
    ADDCOLUMNS (
        VALUES ( 'Table'[Task] ),
        "@Count", CALCULATE ( COUNTROWS ( 'Table' ) )
    )
VAR vResult =
    COUNTROWS ( FILTER ( vTable, [@Count] = 1 ) )
RETURN
    vResult

Tasks updated 2 or 3 times = 
VAR vTable =
    ADDCOLUMNS (
        VALUES ( 'Table'[Task] ),
        "@Count", CALCULATE ( COUNTROWS ( 'Table' ) )
    )
VAR vResult =
    COUNTROWS ( FILTER ( vTable, [@Count] IN {2, 3} ) )
RETURN
    vResult

Tasks updated 4 or more times = 
VAR vTable =
    ADDCOLUMNS (
        VALUES ( 'Table'[Task] ),
        "@Count", CALCULATE ( COUNTROWS ( 'Table' ) )
    )
VAR vResult =
    COUNTROWS ( FILTER ( vTable, [@Count] >= 4 ) )
RETURN
    vResult

Forum Discussion

Help with a measure to count

Related content

Count Measure

Counting nulls

Create count measure

Count Values multiplied by a measure

Overlap Count Measure