Matrix - Identifying Repeating Values

[Consmight]

Hello,

I'm trying to add an additional column to this matrix that returns to a value if a percent is repeated three times in a row. For example if a URL row has three 0%'s across in order, I want a column at the end to provide a value. How would I do this?

[Anonymous · Accepted solution]

Hi @Consmight ,

Based on your description, I'd suggest you change the sub-column total.

Flag = 
var _pre1=CALCULATE(SUM('Table'[Percent %]),FILTER(ALLSELECTED('Table'),[URL]=MAX('Table'[URL]) && [Index]=MAX('Table'[Index])-1))
var _pre2=CALCULATE(SUM('Table'[Percent %]),FILTER(ALLSELECTED('Table'),[URL]=MAX('Table'[URL]) && [Index]=MAX('Table'[Index])-2))
return IF(  SUM('Table'[Percent %])=_pre1&& SUM('Table'[Percent %]) =_pre2 && _pre1<>BLANK() , 1)

Sub-total = 
var _val=IF(MAXX('Table',[Flag])<>BLANK(),"Has >=3 consecutive values")
return
IF(HASONEVALUE('Table'[Index]),SUM('Table'[Percent %]),_val)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.