calculating percentage drop in power BI matrix visual i.e. percentage drop between the rows

[qaiseralam]

  I have power BI matrix visual which look like this 

i want to calculate percentage for alternate rows 

percentage for "PERSONLA_DETAIL_FILLED" will be   (130237/224232) * 100

similarly for "OTP_SUBMIT_VALID" will be (119492/130237) * 100 and so on I am not able to write measure for the same . 

Data snap look like this 

[v-xiaotang · Accepted solution]

Hi @qaiseralam 

Thanks for reaching out to us.

You can add an index column through split, as suggested by amitchandak.

Measure1 = 
var _pre= CALCULATE(SUM('Table'[COUNT]),FILTER(ALL('Table'),'Table'[EVENT_TYPE - Copy.1]=MIN('Table'[EVENT_TYPE - Copy.1])-1))
var _this=SUM('Table'[COUNT])
return DIVIDE(_this,_pre)*100

result

But if you don't want to add other columns, you can try this, 

create the measures below,

ID = 
var _len=SEARCH(".",MIN('Table'[EVENT_TYPE]))-1
return value(LEFT(MIN('Table'[EVENT_TYPE]),_len))

Measure2 = 
var _preID=[ID]-1
var _pre= CALCULATE(SUM('Table'[COUNT]),FILTER(ALL('Table'),'Table'[ID]=_preID))
var _this=SUM('Table'[COUNT])
return DIVIDE(_this,_pre)*100

result

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@qaiseralam , You can split the event to number parts separately.

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

and then you can create a separate table with distinct event to

You can get value of last event like

maxx(filter(allselecetd(event), Table[Event] = max(Table[Event]) -1) ,[Count])