Consecutive days of missed appointments

[BEB2023]

Hi There, 

I am trying to get a measure that counts the last consecutively missed appointments in a dataset that looks like in the screenshot below. Essentially, the measure should count all missed appointments (MissedAppt = Yes) since the last appointment that was not missed (MissedAppt = No). I appreciate any help you can provide with this.

Regards

[ThxAlot · Accepted solution]

[sjoerdvn]

something like this I Guess

consecutively missed appointments for ID=
VAR lnmap = CALCULATE(MAX(Table[Date]),Table[MissedAppt]="No")
VAR smap = IF(ISBLANK(lnmap),DATE(1900,1,1),lnmap)
RETURN IF(HASONEVALUE(Table[ID],CALCULATE(COUNTROWS(Table), Table[Date]>smap, Table[MissedAppt]="Yes"))