Forum Discussion

kararandle2710's avatar
kararandle2710
Frequent Visitor
6 years ago

Count consective rows containing specifc flag

I'm trying find a way to count consective rows by hour t contains a specfic flag.  So in the table below the count for Parameter C would each have a count on the "m" flag of 1, for the day 1/1/2019. (The flag happens in row 17:00, 18:00 and 19:00, but only needs to be counted as 1, not 3).  Any help would be greatly appreciated.

Kara

 

ParameterDayHourFlag
C1/1/201917m
C1/1/201918m
C1/1/201919m

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi kararandle2710 

     

    You can create a Measure like below.

    Measure = 
COUNTROWS( 
    GROUPBY( 
        'Table', 
        'Table'[Parameter], 
        'Table'[Day], 
        'Table'[Flag] 
    )
)

    This will return the result as below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.