Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |