Trigger

Hi, djalmajr 

According to your description, now I can compeletely understand your requirement, you want to get the special Status of some row of data and show the detail of the status, I have tried my best to try to achieve your needs, you can take a look at my steps and check if it’s useful:

1. Create these calculated columns:

rank = RANKX('Table','Table'[DATA BASE],,ASC,Dense)

Type flag =
 var _lastTIPO=
CALCULATE(MAX('Table'[TIPO]),FILTER('Table',[CONTRATO]=EARLIER([CONTRATO])&&[rank]=EARLIER([rank])-1 ))
return
IF(
    [rank]<>1,
IF([TIPO]=_lastTIPO,1,0),1)

Plan flag =
var _lastPLANO=
CALCULATE(MAX('Table'[PLANO]),FILTER('Table',[CONTRATO]=EARLIER([CONTRATO])&&[rank]=EARLIER([rank])-1 ))
return
IF(
    [rank]<>1,
IF([PLANO]=_lastPLANO,1,0),1)

2. Create these measures:

Count group by CONTRATO =

RANKX(FILTER(ALLSELECTED('Table'),[CONTRATO]=MAX([CONTRATO])),CALCULATE(MAX('Table'[DATA BASE])),,ASC,Dense )

STATUS =
var _currentmax=
MAXX(FILTER(ALL('Table'),[CONTRATO]=MAX('Table'[CONTRATO])),[Count group by CONTRATO])
var _allmax=
MAXX(ALL('Table'),[rank])
return
SWITCH(
    TRUE(),
    [Count group by CONTRATO]=1&&MAX('Table'[rank])<>1,"New contract appears" ,
    MAX('Table'[Type flag])=0&&[Count group by CONTRATO]<>1,"Type has changed",
    MAX('Table'[Plan flag])=0&&[Count group by CONTRATO]<>1,"Plan has changed",
    [Count group by CONTRATO]=_currentmax&&[Count group by CONTRATO]<_allmax&&[Count group by CONTRATO]<>1,"Has been cancelled",
    BLANK())

3. Create a table chart and place it like this:

4. You can also create a calculated table to show the data with special statuses, like this:

Table 2 =

FILTER('Table',[STATUS]<>BLANK())

And you can get what you want.

It’s hard to get the status using calculated columns so that this is the best I can do.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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