Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |