Calculate a value based on another row

[Anonymous]

Hello, 

You can find below a sample of the matrix I am currently working on. 

I have two KPI that are supposed to have a value and a Target. However In my table the targets are empty. 
The Target of the Quality - Corrective & Preventive Actions is supposed to be 80% of the Quality - Performance Total NCR Value. 
The Target of the Quality - Performance Total NCR Remains empty

I tried with a measure (named "a" in my example) to Calculate the value. I used the following formula : 
Calculate(0.8*SUM(Value);Filter(Table;KPIname="Quality - Performance Total NCR Value") which gives me the result 4. 

My model is : 
FactTable             KPI
KPI ID                  KPI ID
Value                   KPI Name
Target 

However I didn't managed to put this value in the  Corrective & preventive target. It seems logical as it's two different KPI and rows. Is there any chance we can do that in DAX ? 

Thanks

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490