Forum Discussion
Himaja95
Helper I
Helper IPowerbi
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
Himaja95Helper I
Helper IThank you for your response Fowmy
The code worked but its not showing the right numbers in the chart.
Yes I am trying to display the targets. and little calculation behind displaying the targets
Systems_Ridership_Gauge = ([SystemWide_Green]+1) * [Ridership Total Last Year All Modes]
Ridership total last year is the (FY 2023 Actual ) column. in the below table
By the above code you sent me its is showing 5.4M instead of 4.1
| Ridership Total Last Year All Modes | Yellow Zone | Green Target | |
| Oct | 2024586 | 2133914 | 2235143 |
| Nov | 3791887 | 3996649 | 4186243 |
| Dec | 5443501 | 5737450 | 6009625 |
| Jan | 7284395 | 7677752 | 8041972 |
| Feb | 9006463 | 9492812 | 9943135 |
| Mar | 11052814 | 11649666 | 12202307 |
| Apr | 12935302 | 13633808 | 14280573 |
| May | 14843310 | 15644849 | 16387014 |
| Jun | 16667821 | 17567883 | 18401274 |
| Jul | 18517737 | 19517695 | 20443582 |
| Aug | 20608348 | 21721199 | 22751616 |
| Sept | 22784781 | 24015159 | 25154398 |