Forum Discussion
Solved
Powerbi
Hi I am getting this error,when i am trying calculate the targets error: Calculation error in measure targets_Ridership(Bus _Ridership_Green):A table of multiple values were supplied ,where a s...
pls try this
why did you write this to the measure?
targets Ridership[PM] = "System Wide Ridership"
The column named PM has three metrics in that one of them is System wide ,this refers to this table.
| Month | Year | Category | PM | Target Description | Target Threshold - Green | Target Threshold Yellow |
| January | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| February | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| March | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| April | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| May | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| June | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| July | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| August | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| September | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| October | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| November | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| December | 2022 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| January | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| February | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| March | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| April | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| May | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| June | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| July | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| August | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| September | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.231 | 0.181 |
| October | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.104 | 0.054 |
| November | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.104 | 0.054 |
| December | 2023 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.104 | 0.054 |
| January | 2024 | Ridership | Systemwide Ridership | Increase from last year, with a 5% tolerance | 0.104 | 0.054 |