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. ...
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.