SumIF function like in Excel in Power

[Anonymous]

Hi, I'm new to this and I hope someone can help me. I'm having issue on sumif functions in power bi. I can't figure it out how to solve this. 

On my excel, I have this formula on column Q: = (1- ([@Overdue]/[@[total expected folder]]))*[@[total expected folder]]/SUMIF(A:A,A2,P:P)

Note: the [total expected folder] is the sum of M0 ex to M7 Ex in column P

I can't find ways how to have functions like SumIf in excel in power bi. 

[amitchandak]

@Anonymous ,Not very clear.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.