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
pls try this
this worked ,But I have to use the below measure ,which would take the value 1.104 and then I have to calculate the TARGET
SystemWide_Green =
CALCULATE(MAX(targets_Ridership[Target Threshold - Green]),
KEEPFILTERS(FILTER(ALL(targets_Ridership),
targets_Ridership[PM] = "Systemwide Ridership")))The actual table is below one fro calcualting the above measure
| 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.05 |