Sum multiple rows based on condition

[Solle]

Hi All, 

I am about to generate a report and in this report I have a slicer illustrated in the below pivottable allowing one to select a data. I have generated some sample data below:

What I need in powerBI is to sum the InstrumentSecurityID's (ISIN) that are on Repo (portfolioNbr 156) in either portfolio 110 or 120 depending on whether the ISIN is present in portfolio 110 og 120. Please be aware that the same ISIN might be present in other portfolio i.e. Portfolio 150. 

Furthermore the ISIN's that are on Repo one month might be different the next month, so the sum should loop through and sum if it is present in either portfolio 110 or 120. 

I have created the needed layout below, with a slicer for data. Please be aware that it is not absolut necessary that it says 0 in "new holding value" as per below. 

I hope that someone is able to help me perform the above in PowerBI I have tried several things and are not able to come up with a solution, as I am a new user. 

Best Regards,
Solle

[Anonymous]

Hi, @Solle 

Could you provide your pbix file (removing sensitive information), it will help me better understand your data model .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.