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.
Hey all, new to powerBI and having a little trouble with the KPI visulization.
Issue: when using an average measure for some data, the Target Goal in the KPI does not use the average number. It appears to just take the current data number.
Example:
KPI Indicator feild value: 207
Value from my Average measure: 177.78
Using my Average measure for the Target Goal in the KPI produces "Goal: 207.00"
Here's a sample of the data used for the average measure (Average = average(Weekly History[Total Opened])
Week Total Opened
2018-08-19 | 116.00 |
2018-08-26 | 127.00 |
2018-09-02 | 162.00 |
2018-09-09 | 184.00 |
2018-09-16 | 204.00 |
2018-09-23 | 218.00 |
2018-09-30 | 177.00 |
2018-10-07 | 205.00 |
2018-10-14 | 207.00 |
Any ideas would be greatly appreciated!
Cheers, Jeff
Solved! Go to Solution.
Hi @Jeff505
You should modify your measure as below in your scenario.
Measure = CALCULATE(AVERAGE(Table1[Total Opened]),ALL(Table1))
Best Regards
Maggie
Hi @v-juanli-msft , I have a similar requirment and came across this solution, thank you!
Understand that "ALL" removes all filters, but any thoughts how to make this measure work with a date slicer?
Let's say I need to select september dates only, in this case average will be (162+184+204+218+177)/5=189, and the KPI visual will display red - 177 (last value in september), goal 189 (average for september)
So in other words ALL will remove filters for the KPI visual calculations, and yet apply date filter as specified by the date slicer.
Tried with ALLEXCEPT, but it won't help as we are still workign with the same Date column for which filter is not needed (KPI visual) and needed (date slicer)
Thank you!
By simply using ALLSELECTED instead of ALL 😀
Answered my own question. Please disregard the question above.
Hi @Jeff505
You should modify your measure as below in your scenario.
Measure = CALCULATE(AVERAGE(Table1[Total Opened]),ALL(Table1))
Best Regards
Maggie
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |