DOUBT ABOUT POWER BI MEASURES

Hi  Anonymous ,

I created some data:

 

Here are the steps you can follow：

1. In Power Query -- Add Column – Index Column – From 1.

2. Create measure.

MIN_0_DATE_MEASURE =
MINX(
    FILTER(ALL('Table'),
    'Table'[PATIENT]=MAX('Table'[PATIENT])&&'Table'[TOTAL PRESCRIBED]=0),[DATE])

Flag_MEASURE =
var _current=
SUMX(
    FILTER(ALL('Table'),
    'Table'[PATIENT]=MAX('Table'[PATIENT])&&'Table'[Index]=MAX('Table'[Index])),[TOTAL PRESCRIBED])
var _last=
SUMX(
    FILTER(ALL('Table'),
    'Table'[PATIENT]=MAX('Table'[PATIENT])&&'Table'[Index]=MAX('Table'[Index])-1),[TOTAL PRESCRIBED])
var _next=
SUMX(
    FILTER(ALL('Table'),
    'Table'[PATIENT]=MAX('Table'[PATIENT])&&'Table'[Index]=MAX('Table'[Index])+1),[TOTAL PRESCRIBED])
var _maxdate=
MAXX(
    FILTER(ALL('Table'),'Table'[PATIENT]=MAX('Table'[PATIENT])),[DATE])
return
IF(
    _current=0&&MAX('Table'[DATE])=_maxdate,0,
    IF(
    _current=0&&_current=_next,1,0))

Flag =
IF(
    1 in SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[PATIENT]=MAX('Table'[PATIENT])),"1",[Flag_MEASURE])
    ,1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

 

 

Best Regards,

Liu Yang

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