Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Calculate a value based on another row

Hello, 

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

 

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

1 REPLY 1
Anonymous
Not applicable

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.