Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to get my head around something and I'm not sure I'm taking the right approach. I have a table of contract names, an achievement value for each contract and a target for each specific contract. The targets are currently numeric only (will be looking at combining percentages next) and I can get a KPI to show performance against target for each contract when I apply a filter, but I can't get it to reflect an overall postion properly. I use a measure to Sum the target values.
It works fine when individual rows are selected, but the overall is not summarised correctly; instead of totalling all of the performance values and the targets it seems to only be showing the last one? See example below - I'd expect it to show a value f 581 against a target of 583 (failed).
Solved! Go to Solution.
Hi @shill1000,
In that case, you just need to make a little adjustment to above measures:
Measure target = CALCULATE(SUM('KPI'[Target Value]),ALLSELECTED('KPI')) Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALLSELECTED('KPI'))
Best regards,
Yuliana Gu
Hi @shill1000,
You can create two measures and add measures into KPI target area and indicator area, instead of directly adding [SLA Performance] and [Target value] fields.
Measure target = CALCULATE(SUM('KPI'[Target Value]),ALL('KPI')) Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALL('KPI'))
Best regards,
Yuliana Gu
Thanks for that, I hadn;t thought of a measure for both values. However, it fixes one problem and creates another. When I apply a contract filter via the table, a slicer or a page level filter, the KPI isn;t changing to reflect the filter. I was trying to get the KPI to show an overall figure when no selection is made and tehna combined figure if specific contracts are selected?
Hi @shill1000,
In that case, you just need to make a little adjustment to above measures:
Measure target = CALCULATE(SUM('KPI'[Target Value]),ALLSELECTED('KPI')) Measure Performance = CALCULATE(SUM('KPI'[SLA Performance]),ALLSELECTED('KPI'))
Best regards,
Yuliana Gu
That did it, many 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 |
---|---|
104 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
122 | |
110 | |
94 | |
82 | |
77 |